Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Replication service rights issue

Status
Not open for further replies.

Mich

IS-IT--Management
Dec 26, 2000
452
US
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top