Forum Discussion

Jimb2k's avatar
Jimb2k
Level 4
10 years ago

SQL Server Service Group can't bring online on the second node

Hello everyone, Please I need a solution about my SQL cluster in test environnement. I have issues with the service group that I can"t bring it online on the second node. But in the first no...
Basics
business continuity
Cluster Server
Configuring
Installing
Windows Server (2003-2008)
  • Marianne's avatar
    Marianne
    10 years ago

    Not sure I fully understand what is happening at disk level.

    Can you confirm that it is the same diskgroup and volume where you installed on node 1 that was deported from node 1 and then imported on node 2 followed by identical install?

    Can you now with VCS stopped deport and import the diskgroup between the nodes and confirm that the same data/instance is seen by each node when imported?

    I had a similar issue when I configured a SQL cluster the first time.

    Domain user with local admin rights was used for installation, but SQL service account (starting the services) did not have local admin rights.

    This TN helped me solve the issue: http://www.symantec.com/docs/TECH46264

Marianne's avatar
Marianne
Level 6
10 years ago

For testing the intergity of the DATA on the ISCSI partition, I deleted the service group.

Not sure why you did this? 

Once you have installed the SQL instance on both nodes, check that logon account for Services are correct.
Also verify that SQL user has local admin rights on both nodes.

The Service Group should only be created once as per instructions in the manual: 
Chapter 6. Configuring the SQL Server service group