Windows Failover Cluster on Azure to host SQL

Razzi29 331 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 Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,896 questions
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.