January 3, 2005 at 8:26 am
Anyone any experience with doing this on Windows 2000?
Looks like you have to take the entire cluster offline and change the accout, however that's just to reset the password, presumably changing the account entirely would be the same, however I was wondering if anyone had done so before I started messing around.
January 4, 2005 at 5:47 am
Are you talking about the ID/Passwords that run the SQL Server services ? If so, my understanding is that you go into Ent. Manager, make the changes and then either reboot each node or fail over SQL Server to the other server so the change takes effect.
January 4, 2005 at 6:02 am
Not the SQL service accounts themselves, rather the service account that the cluster uses.
January 4, 2005 at 7:18 am
This article might provide some insight. It's focused on if you have to create a cluster account from scratch so it gives you all the permissions needed, etc.
How to manually re-create the Cluster service account (269229)
K. Brian Kelley
@kbriankelley
January 4, 2005 at 10:01 am
Looks like it has most of the information that I'm after, thanks Brian. Special notice needs to be taken with regards to the link 307532 How to troubleshoot the Cluster service account when it modifies computer objects.
I've found that the setspn.exe to be critical when using Windows Auth in a win2k3 domain and not using domain admin accounts for the SQL Service accounts.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply