locked
SQL Server 2005 Changing Service Accounts in a Clustered Environment RRS feed

  • Question

  • I need to change the service accounts for SQL Server 2005 in a active/passive cluster.  What are the steps to change the service accounts for SQL Server and SQL Server Agent?
    Tuesday, March 8, 2011 4:56 PM

Answers

  • Tuesday, March 8, 2011 5:25 PM
  • Hi,

    Please try the following steps:

    1. Change the service account/password on the passive node;
    2. Manually fail over the cluster to passitive node;
    3. Change the service acocunt/password on the new passive node (previous active node).

    Ps. Please use SQL Server Configuration Manager to manage SQL Server service accounts.

    Hope this helps.


    Best Regards,
    Chunsong Feng

    Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    • Marked as answer by WeiLin Qiao Wednesday, March 16, 2011 11:54 AM
    Sunday, March 13, 2011 5:39 AM

All replies

  • Tuesday, March 8, 2011 5:25 PM
  • Hi,

    Please try the following steps:

    1. Change the service account/password on the passive node;
    2. Manually fail over the cluster to passitive node;
    3. Change the service acocunt/password on the new passive node (previous active node).

    Ps. Please use SQL Server Configuration Manager to manage SQL Server service accounts.

    Hope this helps.


    Best Regards,
    Chunsong Feng

    Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    • Marked as answer by WeiLin Qiao Wednesday, March 16, 2011 11:54 AM
    Sunday, March 13, 2011 5:39 AM