solving sql server problems for millions of dbas and developers since 2006



SQL Server DBA Tips SQL Server Developer Tips SQL Server Business Intelligence Tips SQL Server Career Tips SQL Server Tip Categories SQL Server Tutorials SQL Server Webcasts SQL Server Whitepapers SQL Server Tools SQL Server Questions and Answers MSSQLTips Authors About MSSQLTips SQL Server User Groups MSSLQTips Giveaways MSSQLTips Advertising Options

MSSQLTips Facebook Page MSSQLTips LinkedIn Page MSSQLTips RSS Feed MSSQLTips Twitter Page MSSQLTips Google+ Page

SQL Product Highlight

Devart - dbForge SQL Complete

dbForge SQL Complete is a code autocomplete tool for SQL Server Management Studio and Visual Studio. Free and advanced paid editions of this useful add-in offer powerful autocompletion and formatting of T-SQL code that replaces native Microsoft T-SQL Intellisense.

Learn more!








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

By: | 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 



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
*Enter Code refresh code


 
Sponsor Information
Find and fix SQL Server problems before they happen - SQL diagnostic manager now with predictive analysis!

The 10 tools in the SQL Developer Bundle cut the time spent in dull and tedious tasks. Learn more.

Need SQL Server help and not sure where to turn? Reach out to the Edgewood consultants for a Health Check.

Get SQL Server Tips Straight from Kevin Kline.

Join the over million SQL Server Professionals who get their issues resolved daily.

Valuable SQL Server web casts on Performance Tuning, Development, Administration, SSIS and more...

Copyright (c) 2006-2012 Edgewood Solutions, LLC All rights reserved
privacy | disclaimer | copyright | advertise | about
authors | contribute | feedback | giveaways | user groups
Some names and products listed are the registered trademarks of their respective owners.

Edgewood Solutions LLC | MSSharePointTips.com | MSSQLTips.com