How To Change Sql Server Service Account In Sql Cluster : Demo

This is applicable to SQL 2008 and later versions.

Many of us didn’t work on same but must have faced this question in interview. Being Sql dba you must be aware of same for both interview or for some situation where we have to change SQL cluster service account and none of seniors around.

1.      Go to SQL Server active node

2.      Open sql server configuration manager

3.      Go to sql server services option, Select SQL instance , properties

4      change service account of sql server and click apply

5.      Sql server will ask to restart. Let sql server do restart, this will not switch nodes(Active will remain active)

6.      Now go to passive node
7.      Open sql configuration manager
8.      Go to services and check SQl service for which you have change password on active node.
9.      Service account will auto reflect in passive node.

10.      Do same steps for sql server agent.
11.      Once done Please do failover and check sql should able to run on all passive nodes and from different servers in same domain.
Don’t forget to give all windows level permission to service account on passive nodes which you have given on active node

No comments:

Post a Comment