December 1, 2009 at 10:45 pm
HI Everyone,
I am looking to do some administration on a 2 node cluster based on Windows server 2003 Enterprise and SQL 2K5.
I have a few services that are running under the same account as SQLSERVER service.
I believe that it is a best practice to run only SQLSERVER service and the agent service under the same account in a cluster and the rest should have different accounts. Please correct me if I am wrong.
I need to give different accounts to others, but I am wondering how to get around the problem of avoiding failover in case if I just want to change the account and stop the unneeded service, since they are added to the resource group in the cluster.
I know that services can be stopped through config manager, but I do not want the resource group to show a status of being partial offline.
Can anybody please help!!
Regards
Akhil
December 2, 2009 at 4:09 pm
SQLbee (12/1/2009)
HI Everyone,I am looking to do some administration on a 2 node cluster based on Windows server 2003 Enterprise and SQL 2K5.
I have a few services that are running under the same account as SQLSERVER service.
I believe that it is a best practice to run only SQLSERVER service and the agent service under the same account in a cluster and the rest should have different accounts. Please correct me if I am wrong.
I need to give different accounts to others, but I am wondering how to get around the problem of avoiding failover in case if I just want to change the account and stop the unneeded service, since they are added to the resource group in the cluster.
I know that services can be stopped through config manager, but I do not want the resource group to show a status of being partial offline.
Can anybody please help!!
Regards
Akhil
To avoid failover you will need to start/stop the services from Cluster Manager. Wait until you are in a maintenance window to do it.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 2, 2009 at 10:07 pm
Thanks Jason, but do you think a fiailover will not happen if the option of "Affect the group" is not checked for that specific resource.
This is under resource properties under Advanced Tab.
December 3, 2009 at 9:57 am
I would be extremely cautious of using that option. That option is for less than desirable configurations (i.e. quorum is on a shared resource with other drives) or for less necessary services.
Will it prevent failover - yes. I don't think I would use it for the core Services for SQL Server.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply