无法使用SSMS连接到Azure VM [英] Cannot connect to Azure VM with SSMS

问题描述

我已在Azure的资源管理器中创建了一个新的VM，并安装了SQL 2016，现在正尝试通过SSMS从工作站进行连接.我已遵循此

在VM SQL Server上启用了TCP/IP:

已分配DNS条目.万一A记录需要花时间传播，请假过夜吗?

我可以成功地在VM的SSMS上连接到本地SQL服务器，但是当我从远程工作站尝试时，仍然可以得到:

目前我不知所措，还需要设置其他内容...

解决方案

最后弄清了什么不起作用.埋在对此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):

TCP/IP enabled on VM SQL Server:

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

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:

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

解决方案

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.

这篇关于无法使用SSMS连接到Azure VM的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！