SQL Server Pre SQL Installation Checklist (Part 3 of 4)

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


   Free MSSQLTips webinar - "Efficient Monitoring and Management of SQL Server" (click to register)

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

 




Get Started Now - Click here to get your free 14 day trial of SolarWinds Database Insights

Related Articles

Popular Articles




get scripts

next tip button



About the author
MSSQLTips author Chad Boyd Chad Boyd is an Architect, Administrator and Developer with technologies such as SQL Server, .NET, and Windows Server.

View all my tips


Article Last Updated: 2008-06-29

Comments For This Article





download














get free sql tips
agree to terms