Cannot open backup device. Operating System error 5

by

Yeah I just scored this one.

Look in Windows Services. Start > Administration > Services

Find the Service in the list called: SQL Server (MSSQLSERVER) look for the “Log On As” column (need to add it if it doesn’t exist in the list).

This is the account you need to give permissions to the directory, right click in explorer > properties > Shares (And Security)

NOTE: Remember to give permissions to the actual directory AND to the share if you are going across the network.

Apply and wait for the permissions to propogate, try the backup again.

NOTE 2: if you are backing up across the network and your SQL is running as “Local Service” then you are in trouble … you can try assigning permissions or it may be easier to backup locally and xcopy across outside of SQL Server (an hour later).

NOTE 3: If you’re running as network service then SOMETIMES the remote machine will not recognize the network serivce on your SQL Server. If this is the case you need to add permissions for the actual computer itself eg. MyServer$.

More Related Contents:

  1. How to restore to a different database in SQL Server?
  2. How to connect to local instance of SQL Server 2008 Express
  3. Export query result to .csv file in SQL Server 2008
  4. Enable ‘xp_cmdshell’ SQL Server
  5. Sql Server ‘Saving changes is not permitted’ error ► Prevent saving changes that require table re-creation
  6. SQL MERGE statement to update data
  7. How to get the last record per group in SQL
  8. A transport-level error has occurred when receiving results from the server [closed]
  9. How can I load a large flat file into a database table using SSIS?
  10. storing passwords in SQL Server
  11. How does sql server sort your data?
  12. Why is SQL Server 2008 Management Studio Intellisense not working?
  13. Reporting Services permissions on SQL Server R2 SSRS
  14. T-SQL substring – separating first and last name
  15. SQL Server: Split operation
  16. How to implement polymorphic associations in an existing database
  17. How to get week number of the month from the date in sql server 2008
  18. Optional parameters in SQL Server stored procedure
  19. Entity Framework Database.SetInitializer simply not working
  20. Restoring database from .mdf and .ldf files of SQL Server 2008
  21. What is the default transaction isolation level for SQL Server with ADO.NET?
  22. Restrict SQL Server Login access to only one database
  23. T-SQL strip all non-alpha and non-numeric characters
  24. How can I get a trigger to fire on each inserted row during an INSERT INTO Table (etc) SELECT * FROM Table2?
  25. Avoiding IF ELSE due to variable been NULL
  26. Can I pass variable to select statement as column name in SQL Server [duplicate]
  27. SQL Server 2008 Connection Error “No process is on the other end of the pipe”
  28. SSIS LookUp is not dealing with NULLs like the docs say it should
  29. Recursive Child/Parent queries in T/SQL
  30. Forcing code-first to always initialize a non-existent database?

Leave a Comment