Post reply

SQL 2005 Failover Cluster - How to change the Password of the Service Account (Domain Account)

  • January 9, 2009 at 3:14 am

    #126355

    Hello, I need to change the password of the domain account, which is used for the SQL Server services.

    I didn't find any instructions which is the perferred way to do this yet.

    I have two-nodes (active/passive) failover Cluster.

    I guess, that I need to change the password of the account in Active Directory first, but how I have to proceed after that?

    It would be great, if someone can give me a hint.

    Thanks.

  • January 9, 2009 at 5:50 am

    #924062

    Once password is changed in AD just use SQL Server configuration manager and change the passwords there.

    MJ

  • January 9, 2009 at 6:18 am

    #924085

    Thanks! Should I change the password on the active or on the passive node first?

    Best regards

  • January 9, 2009 at 6:20 am

    #924087

    On the active as this is going to be trying to connect / authenticate actively.

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • January 9, 2009 at 6:26 am

    #924093

    Thanks a lot!

  • January 9, 2009 at 6:30 am

    #924098

    You're welcome.

    Side note, I know there are some utilities that the SE's I used to work with used to change them all at once when we did this. Saved a bunch of time and headaches. I don't know what tool they were using but it might be worthwhile to search the web a bit if you have a bunch to change.

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

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

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