Return
-
Title
LOGSHIPPING: Error: SLS_LogShipping_Add_Cleanup_Job failed -
Description
When setting up logshipping, received error:
"Error: SLS_LogShipping_Add_Cleanup_Job failed" -
Cause
SQL Server service account and SQL Server Agent service account must have sysadmin permission on accessing the publisher's and vice versa
-
Resolution
Verify that the accounts starting SQL Server service and SQL Server Agent service have the sysadmin permission to access not only the Publisher server, but also the Subscriber SQL Server. The simplest method is to use a domain account having sysadmin rights on both servers. Then re-access the log shipping set up..