与 SQL Azure 数据库实例相关的连接错误

与 SQL Azure 数据库实例相关的连接错误

我使用 Azure SQL 数据库服务,尝试连接到托管数据库的服务器,但在特定网络中无法连接,但是,如果从其他 wifi 网络可以连接。执行 telnet 到端口 1433,但没有响应。另一个事实是,我已经在 Azure 防火墙中配置了相应的 IP,我可以向互联网提供商询问,或者这是我配置不足的问题,我提前谢谢您,错误如下:

TITLE: Connect to Server
Cannot connect to server.database.windows.net.

ADDITIONAL INFORMATION:
A network-related or instance-specific error occurred while establishing a
connection to SQL Server. The server was not found or was not accessible. 
Verify that the instance name is correct and that SQL Server is configured 
to allow remote connections. (provider: TCP Provider, error: 0 - An error 
occurred during the connection attempt because the connected party did not 
respond properly after a period of time, or the established connection 
failed because the connected host was unable to respond). (Microsoft SQL 
Server, Error: 10060)

For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver-10060-database-engine-error

An error occurred during the connection attempt because the connected party 
did not respond properly after a period of time, or an error occurred in the 
established connection because the connected host was unable to respond.

翻译www.DeepL.com/Translator(免费版)

答案1

该错误Microsoft SQL Server, Error: 10060可能与网络无关。

证据就是形式一些您可以连接到该 Azure SQL 数据库的机器。

对于那些无法连接的机器,端口 1433 可能已关闭。请确保在虚拟机的 Windows 防火墙上启用了 1433 出站,因为默认情况下也不允许这样做。

如果您从该机器启动 SSMS,它应该会自动要求您设置该规则:

在此处输入图片描述

相关内容