Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 High Availability (2008)
 Change SQL Service acct on active active cluster

Author  Topic 

ajn3341
Starting Member

5 Posts

Posted - 2013-08-12 : 15:26:13
I've got a SQL 2008 active/active cluster, and i need to change the SQL service accounts for both instances. Can anyone provide step-by-step instructions on best way to do this?
Thanks in advance!

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2013-08-12 : 15:27:08
You just need to run SQL Server Configuration Manager and change the service accounts in there on the active node. It'll update the other node. For it to take effect, you'll need to restart the services.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

ajn3341
Starting Member

5 Posts

Posted - 2013-08-12 : 15:39:57
Thanks for the response!
Normally for standalone instance in Configuration Manager it prompts to restart the service - is that expected for a clustered instance?
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2013-08-12 : 16:03:52
Yes. Any changes that require a restart will prompt.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

ajn3341
Starting Member

5 Posts

Posted - 2013-08-12 : 16:13:23
Thanks so much!
Go to Top of Page
   

- Advertisement -