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.