Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Replication fails Expand / Collapse
Author
Message
Posted Friday, July 11, 2014 12:40 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 6:40 AM
Points: 5, Visits: 29
Hi. New to this forum, and definitely not an SQL expert or SQL programmer. I have an SQL database that I want to replicate to two other servers. I have set this up and played with the settings many many times but I can never get replication to work.
The initial snapshot works and mostly everything looks ok, and when I make a change to the database the replication monitor shows that transactions were sent, but they are never applied to the other servers. All servers are running Windows 2008 R2 operating system. The source server is SQL Server 2008, and the two subscription servers are SQLEXPRESS 2008.
There is also a strange error that I cannot resolve. I get continuous errors for the queue reader agent, saying it cannot connect to the source database using the user name "PSS4$". But PSS4 is the server name, not the user name. I expected that I had typed the user name in incorrectly somewhere but I can not find any such instance.
Also this is a push subscription and not supposed to be updatable from the other servers, so I do not think that the Queue Reader agent should even be running.

Any help? Thanks.
Russ
Post #1591776
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse