IP Floating

Question

Hello,

I would like to have some opinions in order to know if I create a load balancer rule with a floating ip, will allow me to use that as listener of a Microsoft SQL Server always on group , that I will have on some vm's at the backend pool.

Thank you

Answer 1

HI @Cinthia Rodriguez

Welcome to Microsoft Q&A Platform. Thank you for reaching out & hope you are doing well.

I would like to have some opinions in order to know if I create a load balancer rule with a floating ip, will allow me to use that as listener of a Microsoft SQL Server always on group , that I will have on some vm's at the backend pool.

Yes, creating a load balancer rule with a floating IP can indeed be used as a listener for a Microsoft SQL Server Always On group.

Refer this doc: Configure a load balancer & availability group listener (Azure portal) - SQL Server on Azure VMs | Microsoft Learn

---

If above is unclear and/or you are unsure about something add a comment below.

Please don’t forget to close the thread by clicking "Accept the answer" wherever the information provided helps you, as this can be beneficial to other community members.

Regards,

Rohith