Connecting local SSMS to Sql Server High Availability running on virtual machines in Azure

Question

We are currently running a High Availabilty SQL Server using two VMs in Azure with a Load Balancer. We would like to be able to connect SSMS running locally on our machines to that SQL Server and are running into some issues that I hope are easily solved by someone who knows what they are doing.

How do I configure the NSG and other azure bits to allow me to connect my local SSMS to this SQL server farm?

score 0 · Answer 1 · answered Nov 15 '17 at 06:05

0

How do I configure the NSG and other azure bits to allow me to connect my local SSMS to this SQL server farm?

Do you create Public IP addresses with those VMs, if yes, we can add port 1433 to NSG inbound rules, and connect it via public IP addresses.

Also we should add port 1433 to windows firewall inbound rules.

answered Nov 15 '17 at 06:05

Jason Ye

2,399
1
8
10

There is a PIP on the load balancer, but not the VMs themselves. Will I have to add PIP's to those? – Snarfblatt Nov 16 '17 at 16:40
Yes, we can add pip to them. – Jason Ye Nov 16 '17 at 16:41

Connecting local SSMS to Sql Server High Availability running on virtual machines in Azure

1 Answers1