Post reply

sa password changed - replication stopped working

  • January 4, 2008 at 12:02 pm

    #91484

    One of our administrators has changed sa password on SQL server and push transact replication stopped working. Is there a simple way to fix it without recreating it?

  • February 13, 2008 at 6:05 am

    #777777

    Hello,

    After reading your question I assume that your replication setup uses the 'sa' account to connect to the subscribers as well. If thats the case and the password there changed to, you'll have to change the properties of your connection setup to the subscribers. You do this in the Replication Setup / Subscribers.

    However, may I suggest you use a separate user for replication, and not the 'sa' account. Especially since the 'sa' account is bound to change password in the future again due to whatever policies and rules your company enforces.

    With kind regards,

    Koen Matthijs

  • February 13, 2008 at 9:10 am

    #777902

    Thank you for your help!

  • February 13, 2008 at 9:15 am

    #777905

    Use the service account as the connection property string in your sql server replication rather than using sa account as that account gets its password changed depending on the business security needs.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

Viewing 4 posts - 1 through 3 (of 3 total)

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