Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Cannot Open Backup Device. Operating System Error
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

9 Posts

Posted - 07/03/2008 :  14:20:02  Show Profile  Reply with Quote

I am having trouble trying to get MSSQL to backup to a network drive. This is the setup:
+ MSSQL on Windows Server 2003 logged in under Win Auth.
+ Shared drive on Vista desktop PC (although same issue happens on XP).
+ Server and PC are in the same workgroup (no domain only workgroup).
+ PC allows everyone full control to share.
+ Drive and folder can be navigated to through Windows Explorer without the need for a password ("Password protected sharing" is turned off).

The error I am getting is:
Cannot Open Backup Device 'path_to_file'. Operating system error 5(error not found).

Script being used:

	TO DISK = N'\\path_to_file\MyDBBackUp.BAK'
	NAME = 'Full Database Backup',

As the network is not on a domain, I can not explicity give the server user permission. None the less, the drive can be viewed/modified through Windows Explorer.

I've just noticed that while typing this post that the "MSSQLSERVER" service is running as "Local system account". Is it therefore likely that this local account does not have access to external resources? Should I be running the service with a non local account, for example an account that has Admin permissions?

Thanks :)

Flowing Fount of Yak Knowledge

7174 Posts

Posted - 07/03/2008 :  14:23:47  Show Profile  Reply with Quote
Should be running in domain account.
Go to Top of Page

Posting Yak Master

100 Posts

Posted - 07/03/2008 :  23:13:19  Show Profile  Send maninder a Yahoo! Message  Reply with Quote
yes check your credentials, also the remote drive Security. Add your Credentials to the Share or the username the JOB is RUnning under.

Database Painter.. Leaving strokes, that amaze! and inreturn, put value to your Work. I am a Database [Architect / Administrator]
Go to Top of Page

Flowing Fount of Yak Knowledge

7266 Posts

Posted - 07/04/2008 :  01:13:34  Show Profile  Reply with Quote
They are in workgroup. Try start sql services with regular windows account and give that account permission to access the share.
Go to Top of Page

Starting Member

9 Posts

Posted - 07/04/2008 :  12:51:46  Show Profile  Reply with Quote
Thanks everybody. Setting the service account to an appropriate windows account did the trick :)
Go to Top of Page

Starting Member

1 Posts

Posted - 06/11/2013 :  03:58:52  Show Profile  Reply with Quote
add Windows credential in Control Panel-->Credential Manager

solved in my case
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000