Identify and resolve SQL Server problems BEFORE they happen with SQL diagnostic manager

SQL Server Pre SQL Installation Checklist (Part 3 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 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

 

Related Tips: More | Become a paid author

Last Update: 6/29/2008

Share:

Share

Tweet

Free SQL Server Learning Building Blocks for Your SQL Server Career Database development best practices What Are You Waiting For?

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 diagnostic manager delivers response in minutes, not hours!" SQL Backup Pro was the smartest kid at school. Head of the class for compression, encryption and centralized management. Discover why. Do you need some help to solve SQL Server problems you are facing? Solving SQL Server problems for millions of DBAs and Devs since 2006. Join now. Free Web Cast - Database development best practices by SQL Server MVPs Grant Fritchey and Jeremy Kadlec