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): |
About Chad Boyd
Chad is an Architect, Administrator, and Developer with technologies such as Sql Server (and all related technologies), Windows Server, and Windows Clustering. He currently works as an independent consultant and also spends a significant amount of time writing, talking, presenting and blogging about Sql Server in person and online at http://mssqltips.com. In the past, Chad has worked with companies and organizations such as Microsoft Corporation and The American Red Cross, and provided consulting/support services at companies such as Bank of America, HP, Citigroup, Qualcomm, Scottrade, TJX, SunTrust, and Zurich Financial Services. For over 3 years with Microsoft Corporation Chad was responsible for providing onsite and remote support, guidance, and advice with SQL Server products to some of Microsoft’s foremost enterprise customers running the largest, most complex SQL Server installations and configurations in the world. This included all SQL Server products and versions, including SQL Server 7.0, 2000, 2005, and recently 2008, the SQL Server database engine, Reporting Services, SSIS/DTS, Notification Services, and Analysis Services on both 32 and 64 bit systems. Chad's primary responsibilities today include troubleshooting critical server situations, performance tuning and monitoring, disaster recovery planning and execution, architectural guidance for new Sql Server related deployments, and delivering deep technical workshops/presentations/proof-of-concept sessions covering a variety of technologies and functionality. Chad regularly posts Sql Server related content, tools, and advice with the mssqltips team at http://blogs.mssqltips.com/blogs and http://mssqltips.com. Chad can be contacted via his blog or email at chad dot boyd dot tips at gmail dot com.
