Learn more about SQL Server tools

mssqltips logo
 

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

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

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


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

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

 



Last Updated: 2008-06-29


get scripts

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