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.
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:
Post a Comment