I'm attempting to set up a server for backup/disaster recovery/test purposes. Judging by the outline from the business unit and purpose of this server I have decided to use snapshot replication. I created a publisher and distributor on the production server (server1) and created a subscription on the backup server (server2). Everything seems to be running fine on each server, but the replication isn't completing. When I check the job history at the subscriber (pull) I see the following:
"SQL Server Agent could not access the replication agent. Use the DCOMCNFG utility to confirm that the SQL Server Agent Windows account has permissions to launch the replication agent. The step failed."
I also get this message when trying a push subscription. I don't know too much about DCOM so I'm kind of driving blind there. I did change the logon accounts for the SQLSERVERAGENT to a domain account with admin rights.
This is SQL 2000 SP3. Does anyone have any ideas or leads for me?
-If it ain't broke, break it and make it better.
"SQL Server Agent could not access the replication agent. Use the DCOMCNFG utility to confirm that the SQL Server Agent Windows account has permissions to launch the replication agent. The step failed."
I also get this message when trying a push subscription. I don't know too much about DCOM so I'm kind of driving blind there. I did change the logon accounts for the SQLSERVERAGENT to a domain account with admin rights.
This is SQL 2000 SP3. Does anyone have any ideas or leads for me?
-If it ain't broke, break it and make it better.