Learn more about SQL Server tools

mssqltips logo
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

SQL Server Post Cluster Configuration Checklist (Part 2 of 4)


By:   |   Last Updated: 2008-06-29   |   Comments   |   Related Tips: 1 | 2 | 3 | 4 | More > Clustering

This is the second checklist in the process - run through it just after you form the cluster, or prior to installing SQL Server in any environment.

Server Cluster Post-Installation Checklist

Check

Pass Fail
Create MS DTC and configure completely
Verify priority of cluster network(s) - all Private networks have priority over Public
Verify Quorum disk configuration (location, log size)
Disable NetBIOS for Cluster IP Address
Verify all the server cluster IP addresses can be resolved inside and outside of the server cluster
Verify the server cluster's name can be resolved inside and outside of the server cluster
All groups containing disk resources can fail over to all nodes
Verify the Cluster Group resource group can fail to all nodes
Verify the MSDTC resource group can fail to all nodes
Increase the cluster log size
Kerberos enabled (if needed; requires Windows 2000 Service Pack 3 or higher or Windows Server 2003)
If antivirus software is installed, set filter to exclude the \MSCS directory on the quorum, all Sql extensions, Sql Server program files path, large ETL paths, etc.
Verify minimum of 2 cluster networks configured to support internal cluster communications
Verify all cluster network configurations (communications)
Verify cluster registry entries were written correctly (HKLM\Cluster)
Verify event logs do not contain errors or warnings, especially with relation to the ClusSvc.  Ensure entries exist stating confirmation of forming/joining of/to cluster
 

Last Updated: 2008-06-29


next webcast button


next tip button



About the author




Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 


Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



    



Learn more about SQL Server tools