This is the third checklist in the process – run through it just before installing SQL Server in any environment.
SQL Clustering Pre-Installation Checklist
|
Check |
Pass |
Fail |
| No errors that may interfere with install in Event Viewer |
|
|
| SQL 2005 – Sql service account given the “lock pages in memory” local permission on all nodes in cluster (if desired) |
|
|
| SQL 2005 – Sql service account given the “Perform Volume Maintenance tasks” local permission on all nodes in cluster (if desired) (for instant file init) |
|
|
| Server cluster properly installed and thoroughly tested |
|
|
| Resource group containing the disk to be used during the install renamed |
|
|
| All nodes have access to the installation path (if using a network share) |
|
|
| Domain account(s) and Group(s) created for SQL Server-related service accounts |
|
|
| Installation account (ideally Cluster Admin account) has privilege at domain level to ADD ACCOUNTS to each of the Domain Groups for Sql Server-related accounts |
|
|
| RPC, Task Scheduler, MSDTC, and Sql Server VSS Writer (Sql 2005, if prior installations) services running |
|
|
| SQL 2005 – Remove any prior SNAC installations |
|
|
| SQL 2005 – LOGOFF all existing Terminal Services, RDP, remote desktop client connections to all nodes except single installation instance |
|
|
About Chad Boyd
Chad is an Architect, Administrator, and Developer with technologies such as Sql Server (and all related technologies), Windows Server, and Windows Clustering. He currently works as an independent consultant based in the Washington, DC area, and also spends a significant amount of time writing, talking, presenting and blogging about Sql Server in the local DC area and online at http://mssqltips.com. In the past, Chad has worked with companies and organizations such as Microsoft Corporation and The American Red Cross, and provided consulting/support services at companies such as Bank of America, HP, Citigroup, Qualcomm, Scottrade, TJX, SunTrust, and Zurich Financial Services. For over 2 years with Microsoft Corporation Chad was responsible for providing onsite and remote support, guidance, and advice with SQL Server products to some of Microsoft’s foremost enterprise customers running the largest, most complex SQL Server installations and configurations in the world. This included all SQL Server products and versions, including SQL Server 7.0, 2000, and 2005, the SQL Server database engine, Reporting Services, SSIS/DTS, Notification Services, and Analysis Services on both 32 and 64 bit systems. Chad's primary responsibilities today include troubleshooting critical server situations, performance tuning and monitoring, disaster recovery planning and execution, architectural guidance for new Sql Server related deployments, and delivering deep technical workshops/presentations/proof-of-concept sessions covering a variety of technologies and functionality. Chad regularly posts Sql Server related content, tools, and advice with the mssqltips team at http://blogs.mssqltips.com/blogs and http://mssqltips.com. Chad can be contacted via his blog or email at chad dot boyd dot tips at gmail dot com.
