Requirements for a SQL Server Windows failover cluster source environment

Refer to the following sections for a SQL Server Windows failover cluster source environment requirements:

• Source host requirements

• Network access requirements for SQL Server

Requirements for Windows failover cluster source environments

When adding a Windows failover cluster as source environments with either SQL Server Failover Cluster Instance or Always On Availability Group, all nodes of the cluster must meet the requirements described in this document.

• When discovering or refreshing Failover Cluster instance or Always On Availability Group environments:

  • The Staging Server must be able to connect to the Cluster IP Address using the RPC / Remote Registry port TCP 445.

• The availability group to be added as the source cluster environment must have a listener present. 

  • AG listener is required for AG cluster discovery. This is implemented on AG cluster discovery as a fail safe if AG database authentication configuration changes down the line, ensuring the Delphix engine has a way to reach the cluster and continue certain operations.

• For source Availability Groups, the Availability Group Listener must be configured with a TCP Port, such as the SQL Server default 1433.

• Connectivity to the Cluster IP Address can be tested using the following PowerShell command. This command should be run from the Staging Server, and specify the Cluster Hostname:

  Copy

  New-Object System.Net.Sockets.TcpClient("aodns-fc.mydomain.local", "445")