Saturday, February 28, 2015

Requirements to start SQL Cluster installation

Copy  SQL software and SP   in both nodes
Make sure you login by  Service Account and installation by service account
Service Account Permission:
Local Admin, Full control, Creating computer objects(MSDTC  + SQL Cluster)
2 computer objects(MSDTC + SQL Cluster) should be created and disable
Windows cluster should have full control on SQL Cluster
Both  windows boxes(Nodes) should be same version and edition
Log in by Service Account in  both Nodes verify permission (Local Admin + Full ctrl)
Windows cluster name and IP
Quorum is installed in Q Drive
M Drive is available for  DTC
Shared disks is online , available , right name and able to failover
Run below command to verify available resource
cmd > cluster res
Moving Available Storage from Node1 to Node2(cmd run as administrator)
cluster group "Available storage" /move
Verify Available Storage Moved or Not-----------
cluster group "Available storage" /move: <NodeName>
Moving Quorum
cluster group "cluster group" /move: <NodeName>
C and F both dirves are in both nodes
Verify  MSDTC VIP and SQL Cluster VIP
VIP and object  name should be verified  in below command
cmd  > nslookup  <VIP>
VIP should not showed in below command
cmd > arp -a
Verify Networks
Run cluster validation report
Verify report properly
=======================================================
Add all features + Roles in both nodes
Install DTC
Test Failover Failback test for DTC
Again run cluster  Validation Report
Move all resources in Node1
===========================
Start SQL Cluster Installation

No comments:

Post a Comment