asp.net - Azure Web 应用程序错误，没有已知的此类主机

Question

在本地运行网络应用程序时，连接到数据库没有问题，

将 Web 应用程序部署到 Azure 后，数据库(也是 Azure)连接尝试抛出以下错误:

[Win32Exception (0x80004005): No such host is known]

[SqlException (0x80131904): 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 - No such host is known.)]

数据库固件设置:允许访问 Azure 服务:设置为开启

关于如何排除/解决此问题有什么想法吗？

Answer 1

这可能是由于将连接字符串粘贴到Data Source=

之后造成的

connectionString="Data Source=Server=...."

相反，它应该是

connectionString="Server=...."