0

I've created a new VM in resource manager on Azure with SQL 2016 installed and am now trying to connect via SSMS from my workstation. I have followed this guide but still receive "A network-related or instance-specific error occurred..." at this point and am not sure what else to check. Telnet also fails on port 1433 but I can successfully RDP into the server.

Network Security Group configuration (opened all ports in desperation): enter image description here

TCP/IP enabled on VM SQL Server: enter image description here

DNS entry assigned. Have left overnight in case the A record takes time to propagate? enter image description here

I can successfully connect on the VM's SSMS to the local SQL server, but when I try from my remote workstation I still get: enter image description here

I'm at a loss at this point for what else needs to be setup...

Daniel
  • 1,364
  • 1
  • 19
  • 34

1 Answers1

0

Finally figured out what wasn't working. Buried in the comments on this stackoverflow was:

Also REMEMBER to ENABLE SQL Server Browser service. Have setup a number of SQL servers in my time... Yet this step always seems to have different scenarios involved :)

It appears that this wasn't done in the automated SQL setup via the VM installation. I can now connect to the VM remotely with SSMS.

Community
  • 1
  • 1
Daniel
  • 1,364
  • 1
  • 19
  • 34
  • I had the same problem, what I should change was: click on th VM in AzurePortal --> SQL Server configuration --> Change SQL Connectivity to public – Kaja Dec 06 '18 at 13:51