Monday, June 9, 2014

SQL Server Cluster(Active/Passive) installation high level steps

SQL Server Cluster(Active/Passive) installation steps:

Pre-req:
1.Windows Cluster Services installed on both nodes (Windows Admin responsibility)
2.Make sure test the validation report for storage,cluster servers .....etc.
    If any issue then contact windows admin
3.IP addresses required for
    Node1 IP address
    Node2 IP address
    Windows Cluster IP
    SQL Server Virtual IP ( this could be used Cluster Network  Configuration step)
     (unmark the DHCP column and fill the address column with the value of this IP)
    optional :   MSDTC IP( if you use distributed transactions then it required)
 4.Use AD group to install the SQL Server
Install:
5. High level steps
   5.1 Install SQL Server on Node1
   5.2 Then add on Node2 to install SQL Server
   5.3 Reboot the both nodes    

No comments:

Post a Comment