In this post, we will talk about the Pre-Installation SQL Server Failover Cluster Checklist that might be helpful for you to prepare the environment. Please note that they steps are meant to help you get started. Please use your own service accounts and passwords for pre-production deployments.
Assuming that you have all the hardware and environment in place, with the Windows Server running on a minimum of 2 Nodes, here are the items to check before installing SQL Server on a Cluster.
4. The System Date and Time should be in Sync with the Domain Controller. Use NET TIME command to check.
5. Ensure all resources in the Cluster is online. For example, Disk, Network, MSDTC etc.
6. Remote registry service should be started.
7. Ensure the following Services are started:
Domain Name: YourCompanyDomain.com Node 1 Name: SQLNode1 Node 2 Name: SQLNode2 Node 1 Public Network IP Address/Mask: 192.168.1.1/255.255.255.0 (Client connection Network Interface on Node 1) Node 2 Public Network IP Address/Mask: 192.168.1.2/255.255.255.0 (Client connection Network Interface on Node 2) Private Network IP Address on Node1: 10.10.10.1/255.0.0.0 (Cluster Heartbeat) Private Network IP Address on Node2: 10.10.10.2/255.0.0.0 (Cluster Heartbeat) Admin Account Name and Password: Administrator/[email protected] Windows Cluster Virtual Name: SQLCLUSTER
Even though the Windows Cluster Virtual Name has a DNS Entry, this is not the connection which which client data connections should point to.
Windows Cluster IP Address: 192.168.1.3/255.255.255.0 MSDTC IP Address: 192.168.1.4/255.255.255.0 (Ensure a Static IP Address) MSDTC Network Name: MSDTC (Will have DNS Entries) Virtual SQL Server Name (default or named): SQLCLUSTER\MyInstance
The Virtual SQL Server name is what the SQL Client Connections should point to.
Virtual SQL IP Address: 192.168.1.5/255.255.255.0 Cluster Service Account Name and Password: ClusterSVC/[email protected] SQL Service Account Name and Password: SQL2K16SVC/[email protected] SQL Server Domain Group Name: SQL Server Admins MSDTC Disk Letter: Assign a Clustered Shared Disk for Microsoft Distributed Transaction Coordinator Service, For Example, Drive M:
We hope that this post about SQL Server Failover Cluster Checklist was helpful for you to get started. If you have any questions or feedback, do not hesitate to comment below in the comment section.
Comments are closed.