Post reply

What are the best practice steps to change SQL service password for active/active nodes on SQL failover cluster environments?

  • September 21, 2010 at 4:03 pm

    #145397

    Can some one please provide the steps or the related site to change the sql service account password on active/active nodes on sql 2008/2005. Thanks

  • September 21, 2010 at 8:34 pm

    #1225306

    Do it one instance at a time.

    Stop the instance dependencies from cluster management.

    Change the password in services.msc

    start the instance from cluster management.

    Repeat the process for the other instance.

    I recommend stopping the instance so that the service does not switch to the other node while changing the password.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • September 22, 2010 at 8:40 am

    #1225656

    Thanks for the reply, but do you recommend any link that shows step by step procedure.

  • September 22, 2010 at 1:14 pm

    #1225883

    Here you go:

    http://www.sqlservercentral.com/Forums/Topic649599-146-1.aspx

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

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

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