SQL Server Cluster installation is very comprehensive task
that involve network, hardware and DBA team, there are many resources available
on internet to set it up, but I am summarizing all in one single note to ease
DBA to set it up, I used several this procedure several times to set it up.
This Installation is done with SQL SERVER 2008 R2 and
Windows Server 2008 R2.
Server Configuration
and IP’s
Server Name
|
Physical / Virtual
|
IP
|
DBSERVER1
|
Physical
|
10.10.1.51
|
DBSERVER2
|
Physical
|
10.10.1.52
|
DBCLUSNAME
|
Virtual (Cluster Group IP)
|
10.10.1.53
|
DBSRV
|
Virtual (SQL Network Name)
|
10.10.1.54
|
SQL Server Instance
Name
Cluster Installation Always use Instance Name while SQL
Server Installation
Connection String = DBSRV\INSTANCE = DBNAME
Create Database Alias on Client Machine
Installation user /
admin user
Domain User “dbadmin.user”
Local Authentication
·
dbadmin.user is now part of Administrators group
at DBSERVER1, DBSERVER2
Prerequisites
·
Make Sure that Cross cable is plugged in for
private network between 2 nodes
·
Public Network Interface priority is greater
than private network – check Network and Connection -> Advance menus”
·
Create Cluster Application and Qourm at MSCS
·
Create Storage devices and add in Cluster
Application
·
Add dbadmin.user into both server administrators
account
·
Grant domain admin to dbadmin.user for
installation only
·
Make sure that dbadmin.user is defined in proper
location of AD, otherwise GP security apply.
·
Login always with dbadmin.user account
·
Install Pre-Requisite Role/ Features
o
Application Server Role
§
Inbound and Outbound transaction must be check
o
Failover Cluster
o
Multipath I/O (If ISCSI SAN used with multipath)
·
Verify/Create Cluster , make sure that no scan
checking window comes on window while validate
·
Make Sure that SQL NETWORK NAME manually added
into Active directory computer catalog before start SQL installation
·
Turn on ICAMP packet in firewall for ping on all
servers ”netsh firewall set icmpsetting 8”
·
Run Local Security policy (secpol.msc) - >
Local Policies -> User Rights and Assignment, add Administrators into “lock
pages in memory)
·
Run Local Security policy (secpol.msc) - >
Local Policies -> Security -> set Elevate without prompt at “User Account
Control – Behavior for prompt for administrator”
·
Disable SAN Network in Failover Tree ->
Network (its option, disallow cluster to use SAN network, because it uses
Public Network)
·
Inbound Rule for Firewall on all nodes, 1433
·
Verify that the Cluster Service account (installing
user cluster in windows 2008 R2) has explicitly been given the following
rights:
o
Log on as a service
o
Act as part of the operating system
o
Back up files and directories
o
Adjust memory quotas for a process
o
Increase scheduling priority
o
Restore files and directories
·
Restart host after creating cluster and before
installation
·
Make sure SQL virtual name must be defined in
DNS manually with Update PTR check box before installation SQL Server
Installation
·
Run SQL Server Setup on first node and select
Create Cluster and Install SQL Server, Once done, restart Server,
·
Run SQL Server Setup on Another node and select “Add
Node to cluster”
