Answered by:
SQL Server 2005 Changing Service Accounts in a Clustered Environment

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
-
hi,
have a look at this:
http://msdn.microsoft.com/en-us/library/ms143746(v=sql.90).aspx
regards,
Stef
- Proposed as answer by StefDBAMicrosoft employee Monday, March 14, 2011 9:40 AM
- Marked as answer by WeiLin Qiao Wednesday, March 16, 2011 11:54 AM
Tuesday, March 8, 2011 5:25 PM -
Hi,
Please try the following steps:
- Change the service account/password on the passive node;
- Manually fail over the cluster to passitive node;
- 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
-
hi,
have a look at this:
http://msdn.microsoft.com/en-us/library/ms143746(v=sql.90).aspx
regards,
Stef
- Proposed as answer by StefDBAMicrosoft employee Monday, March 14, 2011 9:40 AM
- Marked as answer by WeiLin Qiao Wednesday, March 16, 2011 11:54 AM
Tuesday, March 8, 2011 5:25 PM -
Hi,
Please try the following steps:
- Change the service account/password on the passive node;
- Manually fail over the cluster to passitive node;
- 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