SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Replication fails


Replication fails

Author
Message
russk2t
russk2t
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search