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 |
|
olinmds
Starting Member
25 Posts |
 Posted - 2011-07-29 : 10:50:51
|
| Trying to run a SSMS Agent backup job and drop the .BAK file onto another server (using FULL backup to DISK). This is a new 2K8 clustered box for us and I continue to get the following error: Executed as user: MC\ssis_agent_svc. Cannot open backup device '\\XXXXX\MCShared\XXXXXXX\backup\XXXXXX6.bak'. Operating system error 5(Access is denied.). [SQLSTATE 42000] (Error 3201) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.MC\ssis_agent_svc has local admin rights on both servers and we have been trying to troubleshoot for a couple of days now. Please know that any help is greatly appreciated!!! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
olinmds
Starting Member
25 Posts |
Posted - 2011-07-29 : 13:22:02
|
| Hi Tara,Thanks for your reply!!!I can get in fine as MC\ssis_agent_svc and create file with no issues. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
olinmds
Starting Member
25 Posts |
Posted - 2011-07-29 : 13:59:32
|
| SQL Agent Service is with SSIS_Agent_Srv account. SQL Server (MSSQLSERVER)Service is with different SQL account. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
olinmds
Starting Member
25 Posts |
Posted - 2011-08-02 : 14:19:33
|
| Hi Tara! THANKS!!!!!It worked beautifully once we granted the rights to the other service account! I appreciate your time and help!!!!!! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
SQL Server 2K8 r2 - Agent Backup Job Failure