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.
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.
- Take SQL offline - Change password in AD - Change password in configuration manager - Start SQL
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
16 People are following this question.
