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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem setting up Transaction Replication

Status
Not open for further replies.

YvonneTsang

Programmer
Sep 28, 2001
37
CA
I am having problems with setting up Transaction Replication. I am able to create the publication and the subscription with the wizards and that is fine. My problem is that the tables are not being sent/updated. It seems that the agents have never been started and when I choose to start them, it doesn't do anything. Does anyone know how I would solve this?
 
Check the security[user id] of the sql server agent from Control Panel->Services and if it is setup to run with a certain user credentials, then make sure the password is entered correctly, otherwise you can choose to run it with system credentials.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top