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 |
|
sqlfresher2k7
Aged Yak Warrior
623 Posts |
 Posted - 2012-04-17 : 08:44:07
|
| I got the below error during the backup database..Please help.Executed as user: NT AUTHORITY\NETWORK SERVICE. Cannot open backup device '\\test1\tEST2\ts\abc\test4\Data_Backups\SCORETEST\test_123.bak'. Operating system error 5(Access is denied.). [SQLSTATE 42000] (Error 3201) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed. |
|
|
franco
Constraint Violating Yak Guru
255 Posts |
Posted - 2012-04-17 : 10:18:34
|
| Seems like the account on which sql server agent run, do not have permission to write to the network path (access denied).Franco |
 |
|
|
sqlfresher2k7
Aged Yak Warrior
623 Posts |
Posted - 2012-04-17 : 11:29:51
|
| How i check the sql server agent account.. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-04-17 : 11:54:11
|
| Run SQL Server Configuration Manager (under Start->Programs->Microsoft SQL Server->Configuration Tools). Or run the Services panel under Administrative Tools and look for the SQL Server service, right-click, Properties, Log On. |
|
|
|
|
|
|
BackupError