Cluster SQL Service Account - SQL Server Forums

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 2000 Forums

SQL Server Administration (2000)

Cluster SQL Service Account

Author

Topic

AndyB13
Aged Yak Warrior

583 Posts

Posted - 2005-09-06 : 11:38:44

Hi
I am wondering if someone can help me out here.
I have to upgrade a cluster to SP4 and apply a hotfix tonight ([url]http://support.microsoft.com/kb/893312/[/url]) and i am after a bit of advice.

Windows 2000 advanced server SP4
SQL Server 2000 SP3 (Active/Passive)
Both nodes are domain controllers

I have two isuues i am after a bit of help with

1. I noticed that in the services console of node1 (Active) that the SQL services are set to run under DOMAIN\User but on node2 (Passive) the same services are LocalSystem account.
The SQL account in EM on the virtual server is set to DOMAIN\User. However what i havent checked (and i dont know) is that what happens when it failsover to node2, will it use the DOMAIN\User account or flip to LocalSystem. What should i do, or is this normal, as I have read that the accounts shouldnt be altered through the services console but only via EM.
NB: The cluster services are set to run under DOMAIN\ClusterUser account on both nodes

2. Anyone got any advice/strategies of implementing SP4/Hotfix on a cluster.
This is what i have come up with, in my current situation.

a) Backup DBs
b) Set SQL services on both nodes to the DOMAIN\User account (Same as EM config)
c) Reboot both nodes
d) Login to both nodes with the DOMAIN\User account
e) Ensure node1 is online (originator/owner of the resources)
f) Take SQL Server Agent & Full Text offline
g) Apply the hotfix
h) Reboot both nodes
i) Backup DBs
j) Test failover - both directions (poss another reboot of each node)
k) Install SP4
l) Reboot both nodes
m) Backup DBs
n) Test failover - both directions (poss another reboot of each node)
o) Go to BED!

Hope that makes sense

If anyone can give any advice or resources that would be of great help

Thanks

Andy

Beauty is in the eyes of the beerholder

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-09-06 : 13:48:07

1. Someone didn't use EM to change the services, so that's why they are messed up. To rectify, just change the problem one via the Services applet. And if it fails over before you do this, it'll use Local System on the problem node.
2. You are rebooting too often. There is no need to reboot after the service accounts have changed. You just need to ensure that the instances work on both nodes. Don't you have to install the hotfix after SP4?

Tara

AndyB13
Aged Yak Warrior

583 Posts

Posted - 2005-09-06 : 14:43:19

Thanks Tara

This is what i was thinking but i just wanted some clarification as my knowledge on Clustering is somewhat limited.

With regards to the hotfix i'm not sure as the KB seems to only apply to SP3 or SP3a and the issue is not fixed in SP4.
So i thought that applying the patch on SP3 1st seemed maybe more logical as it fits into my current scenario.

Thanks again

Andy

Beauty is in the eyes of the beerholder

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources