Post reply

Replication woes

  • July 16, 2014 at 6:40 am

    #309996

    Hi. I apologize for posting twice but just noticed that I originally posted to the SQL Server 2005 forum. Maybe that is why I got no answers.

    Anyway I am 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 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

  • July 16, 2014 at 9:52 am

    #1729913

    Which accounts are you using to run the SQL Services on each of the Servers?



    My blog

  • July 16, 2014 at 10:20 am

    #1729930

    Thanks for the reply. To eliminate any permissions issues I am running all accounts under my own personal domain admin account. All servers are in the same domain. I can connect to all servers and see the databases from any of the server machines. Is that sufficient? Once it is proven to work I might change over to a special account with more limited permissions for security reasons.

    Russ

  • July 16, 2014 at 11:13 am

    #1729963

    russk2t (7/16/2014)

    Thanks for the reply. To eliminate any permissions issues I am running all accounts under my own personal domain admin account. All servers are in the same domain. I can connect to all servers and see the databases from any of the server machines. Is that sufficient? Once it is proven to work I might change over to a special account with more limited permissions for security reasons.

    Russ

    Just to be sure, I understood. All SQL Services are running under your account?



    My blog

  • July 16, 2014 at 12:28 pm

    #1729992

    Yes, that is correct.

  • July 16, 2014 at 3:55 pm

    #1730055

    Are you using Transactional Replication?



    My blog

  • July 17, 2014 at 5:27 am

    #1730201

    Yes. transactional. Agent only on distributor.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply