question

mukki avatar image
mukki asked

Need steps to change sql services account to a different account on sql server 2005 active/passive cluster.

Need steps to change sql services account to a different account on sql server 2005 active/passive cluster.
sql-server-2005clusterservice-account
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
Please indicate all helpful answers by clicking on the thumbs up next to those answers. If any one answer solved your problem, please indicate that by clicking on the check box next to that answer.
0 Likes 0 ·
SirSQL avatar image
SirSQL answered
- Take SQL offline - Change password in AD - Change password in configuration manager - Start SQL
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sqlaj 1 avatar image
sqlaj 1 answered
You change the service account through SSCM just as if it were a single instance. You will need to be on the active nod. It will force a restart and fail over. You would then change the account on that node (it will now be the primary) NOTE: I highly recommend TESTING on a non production cluster first. 1. To identify any issues you may run into 2. Test the process to become more familiar with it 3. Document the process for future reference. If you have not read through this you should. SQL2005 http://technet.microsoft.com/en-us/library/ms345578(v=sql.90).aspx SQL2012 http://technet.microsoft.com/en-us/library/ms345578.aspx
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.