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

By: Chad Boyd | Read Comments | Print Chad is an Architect, Administrator and Developer with technologies such as SQL Server, .NET, and Windows Server. Related Tips: More

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

 

Related Tips: More | Become a paid author

Last Update: 6/29/2008

Share:

Share

Tweet

Connect with MSSQLTips.com Follow us on twitter... Let's connect on facebook! Join us on Google+

Comments and Feedback:

Post a Comment or Question

Keep it clean and stay on the subject or we may delete your comment.
Your email address is not published. Required fields are marked with an asterisk (*)

*Name

*Email

Notify for updates

Comments *** NOTE *** - If you want to include code from SQL Server Management Studio (SSMS) in your post, please copy the code from SSMS and paste the code into a text editor like NotePad before copying the code below to remove the SSMS formatting.
*Enter Code

 

Sponsor Information

"SQL doctor is the best SQL product on the market, by far. All of Idera's tools are great, but this is the icing on the cake!" SQL Monitor – For database professionals who need results on Day One. Try it online. What grade do you think your SQL Servers get? Find out with Edgewood's SQL Server Health Check starting at $995. Free Trial: Get Proactive Insight with Spotlight® for SQL Server Enterprise. Solving SQL Server problems for millions of DBAs and Devs since 2006. Join now. The SQL Server Security THREAT - It’s Closer Than You Think