Hello All !
I have some trouble with my SQL Server 2005 Cluster. This is my staging environment:
MS Windows 2003 Cluster MSCS (Enterprise Edition x64 US SP2 R2)
SQL Server 2005 Enterprise Edition x64 US SP3 CU10 with Active / Active role and 12 SQL instances (SQL and Olap)
I have some trouble with a cluster group (clusgrp1) which doesn't want to take online (before it can).
I want to know why the cluster Group CLUSGRP1 can't take online on servernode2 as it work fine on servernode1 ?
I have this error: " SQL Server' ressource was down when 'clusgrp1' cluster group move on servernode2
After some research, I found a "not very friendly" solution: when I put the service account (stdom\svc_dbe_clusgrp1) in the administrator local group and then it runs and all is ok.
I want to know which permissions (or other things) are missing on the servernode1, perhaps it is a good track ? (local policies ?) or a permission cluster group parameters ?
Thanks for advance for your ideas / help - Regards - Have a nice day ! RHUM2
View Complete Post