Search This Blog

Saturday, December 27, 2008

SQL Sever 2005 Cluster Setup Checklist

Beloe are the documents that are good and one should go thru before installing SQL Server 2005 on a cluster .
Server Clusters: Storage Area Networks http://www.microsoft.com/downloads/details.aspx?FamilyID=ea283d46-125f-4f94-9059-87681c0ab587&DisplayLang=en
Guide to Creating and Configuring a Server Cluster under Windows Server 2003 http://www.microsoft.com/downloads/details.aspx?FamilyID=a5bbb021-0760-48f3-a53b-0351fc3337a1&DisplayLang=en
SQL Clustering White paper: .  http://www.microsoft.com/downloads/details.aspx?FamilyID=818234dc-a17b-4f09-b282-c6830fead499&DisplayLang=en
Below is the list of some important thing that we should keep handy before stating cluster installation. These will be required through out the process of installing windows cluster and then SQL cluster.
Parameter
Example
Domain Name
Mydomain.com
Node1 Name
ClusterNode1
Node2 Name
ClusterNode2
Node 1 Public Network IP Address/Mask
192.168.1.1/255.255.255.0
Node 2 Public Network IP Address/Mask
192.168.1.2/255.255.255.0
Private Network IP Address on Node1
10.10.10.1/255.0.0.0
Private Network IP Address on Node2
10.10.10.2/255.0.0.0
Admin Account Name & Password
Administrator/Password
Windows Cluster Virtual Name
WindowsCluster
Windows Cluster IP Address
192.168.1.3/255.255.255.0
MSDTC IP Address
192.168.1.4/255.255.255.0
MSDTC Network Name
MSDTC
Virtual SQL Server Name (Default or Named(
SQLCLUSTER\MyInstance
Virtual SQL IP Address
192.168.1.5/255.255.255.0
Cluster Service Account Name & Password
ClusterSVC/Password
SQL Service Account Name & Password
SQL2K5SVC/Password
SQL Server Domain
SQL Server Admin
MSDTC Disk Letter
M:
Quorum Disk Letter
Q:
Drive Letter For SQL Server Database Files
P:, O:, L:



No comments: