Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
giganteface
Starting Member
2 Posts |
 Posted - 2011-08-25 : 11:26:18
|
| I’m trying to create a SQL Server Agent job for SQL Server 2008 which will issue a BACKUP DATABASE TO DISK statement; we already have a SQL Server Agent job that does this in order to save full backups to the local drive, but now I want to start saving differential backups to a network share. The problem is, no matter what I do I always get an “Operating system error 5(Access is denied.)” error. We’re using Windows authentication mode in SQL Server, the SQL Server Agent service is running as a domain account, this domain account exists in SQL Server and is in the sysadmin role, this domain account has been explicitly added to the NTFS permissions on the folder I’m trying to save to with Full Control access, and the share permissions on this folder are set such that Everyone has Full Control. Am I missing something here? Thanks for any help you can provide! |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-08-25 : 12:01:41
|
| SQL Service (not SQL Agent Service) account needs permissions on the share.Also, make sure the share isn't read only.And use full unc path, not mapped drive letter./ |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-08-25 : 12:03:13
|
| Oh, and make sure UAC is disabled. |
|
|
|
giganteface
Starting Member
2 Posts |
Posted - 2011-08-25 : 17:31:49
|
| That was it, thank you very much :) |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-08-25 : 23:50:17
|
You're welcome  Glad to help. |
|
|
|
|
|
|
Unable to Backup to Network Share