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
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