Thursday 18 July 2013

Microsoft SQL Server 2012 cluster installation step by step

Recently I do a SQL Server 2012 Cluster testing on Hyper-V virtual machine, here is the steps.
Step 1: Run setup.exe from one of the clustered node.
 



 
 
The shared feature directory must set the local path, ehere can't use clustered hard disk


 
The instance root directory must set a local path

 
Choose SQL Server system database hard drive, this hard disk must be clustered.
Configure SQL Server cluster IP.
 
 

 
 
 
Step 2: Check the installation
 
 
 
Step 3: When I try to  move the cluster resource from node1 to node2, encounter a error message , here is the error msg.
Error code: 0×80071398. The operation failed because either the specified cluster node is not the owner of the group, or the node is not a possible owner of the group
 
Oops, I forgot to add the node2 to SQL Server Cluster.
Run the setup.exe from node2, choose Add node to a SQL Server failover cluster and follow the wizard step by step to complete the setup.
 
Step 4: Try again to move SQL Server resource to node2, got another error:
Error code 0x8007174b. Clustered storage is not connected to the node."  
It’s because the shared hard disk not assigned to node2, login to the storage, scroll down to iSCSI targets, select the shared hard disk , right click select properities.
 
 
 
 
Step 5: Complete successfully!

 
 
 
 
 
 
 
 
 
 
 

 
 
 
 
 
 
 

No comments:

Post a Comment