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

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

SQL Product Highlight

Idera - SQL compliance manager

SQL compliance manager is a comprehensive auditing solution that tells you who did what, when and how on your SQL Servers. SQL compliance manager helps you ensure compliance with regulatory and data security requirements.

Learn more!

SQL Server Configuration Checklist

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 informational sheet should be filled out completely prior to starting the installation/configuration of a new cluster or standalone instance. NOTE: Only include user/password information if secure document – if not, simply reference the location to retrieve.

{SQL Instance Name} SQL Config

Copy and paste this entire section for each Sql Instance on the cluster

Parameter	Value
Instance Name
Listening Port
Enabled Network Protocols
Force Encryption?
Cluster Group Name
Virtual Server Name
IP Address 1
Network to Use (IP 1)
IP 1 Subnet
IP 1 NetBIOS Enabled
Data/Log Disks Allocated Tempdb specific?
Cluster Definition/Preferred Owner Order
Cluster Administrator Information	Username: Password:
Type Of Instance (Named, Default)
Program Files location (same location on internal drive on all nodes)
SQL Server Administrator Account
SQL Server Administrator Password
SQL Server Agent Administrator Account
SQL Server Agent Administrator Password
SQL 2005 Service Accounts and Passwords Browser, SSIS, Analysis Services, RS, NS
SQL 2005 Domain Group Names Sql, Agent, Fulltext, Browser, SSIS, AS, NS, RS, etc.
Authentication Mode (Mixed, Windows)	If Mixed, SA password:
Licensing Mode (Per Seat, Per Processor)	Value:
SQL Services Required (Agent, Fulltext, SSIS, RS, NS, etc.)
Memory Allocated To The Instance
AWE Enabled?
SQL 2005 services enabled (CLR, DB Mail, etc.)
SSIS Cluster configuration Dedicated group vs. shared Sql Affect group?	SSIS LUNs:SSIS IPs:SSIS Network Name(s):

Related Tips: More | Become a paid author

Last Update: 6/28/2008

Share:

Free SQL Server Learning

Comments and Feedback:

Sponsor Information

Try the award winning SQL diagnostic manager as a free 14-day trial!

Web-based SQL Server monitoring whenever, wherever.

We fill in the gaps... SQL Server Training, Development, Performance Tuning, SSIS and more

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

Free Web Cast - Building Blocks for Your SQL Server Career by Jeremy Kadlec on Thursday, Feb 23rd