OK, I have setup Log Shipping before on a different box, no problems. Now, with 2 new boxes, I seem to be dead in the water. I run thru everything and then I get this message
I am running SQL Server and the SQL Server AGent under the domain admin account, I have made sure the domain admin has full access to the drive where I am trying to create the backups. Not sure what I may be missing. The error log shows Operating system error 5(access is denied), but I start the services (SQL Server and SQL Server Agent) as the domain admin. Does it not run the maintenance plans under the same account that runs the service? Anyone got any thoughts on this one?
Willie
Code:
Microsoft SQL-DMO (ODBC SQLState: 42000)
Error 3201: Cannot open backup Device
'\\SQL01\backup\utility\utility_logshipping_init.bak'. Device error or device off-line. See the SQL Server error log for more details. BACKUP DATABASE is terminating abnormally.
I am running SQL Server and the SQL Server AGent under the domain admin account, I have made sure the domain admin has full access to the drive where I am trying to create the backups. Not sure what I may be missing. The error log shows Operating system error 5(access is denied), but I start the services (SQL Server and SQL Server Agent) as the domain admin. Does it not run the maintenance plans under the same account that runs the service? Anyone got any thoughts on this one?
Willie