Windows Failover Cluster on Azure to host SQL

Razzi29 336 Reputation points
2022-02-20T19:03:06.487+00:00

I am hoping someone can assist with an issue I am having with finalizing a Windows 2016 Failover Clustering on Azure to host SQL Server instances. I followed Microsoft's best practices and recommendations as per the links below. When deploying this config in Azure is recommended to use an Azure Internal Load Balancer to host clusterip, quorum and SQl instances IP addresses. The issue is that the load balancer is not able to reach to the backend pool which in this case is two server nodes. When I check the server nodes, I cannot see the ports listening when I do something like netstat -an command.

https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/failover-cluster-instance-prepare-vm?tabs=single-subnet

https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/failover-cluster-instance-overview

Windows for business Windows Server User experience Other
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.