无法使用SQL Server Management Studio连接到SQL Azure [英] Cannot connect to SQL Azure using SQL Server Management Studio
问题描述
我已经在Azure门户上创建了一个SQL Azure数据库，现在我想使用SQL Server Management Studio连接到它.我将属性设置如下:
I have create a SQL Azure database on the Azure portal, now I want to connect to it using SQL Server Management Studio. I've set my properties like this:
Server Type:Database Engine:
Server Name:[mycred].database.windows.net
Authentification: SQL Server Authentification
username: myusername
password: mypassword
但是当我尝试使用这些属性进行连接时，我得到一个错误:
But when I try to connecting with these properties I get an error:
建立与SQL Server的连接时发生与网络相关或特定于实例的错误.找不到服务器或 无法访问.验证实例名称正确，并且 SQL Server配置为允许远程连接. (提供者:命名 管道提供程序，错误:40-无法打开与SQL Server的连接) (Microsoft SQL Server，错误:53)
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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)
我在SQL Azure数据库上配置了防火墙.如何解决这个问题?
Whereas I have configure firewall on my SQL Azure database. How to solve this issue?
推荐答案
您的请求尚未离开您的计算机，这就是它返回网络错误的原因.可能有几个问题，并且首先从SQL Server Management Studio开始.您必须具有SSMS R22008.任何非R2版本均将不起作用.
Your request has not left your machine that's why it is returning network error. There could be several issues and first start with SQL Server Management Studio. You must have SSMS R2 2008. Any non R2 version will not work.
以下是您需要执行的测试列表，以对问题进行故障排除并应用解决方案:
Here is a list of test you would need to perform to troubleshoot the problem and apply solution:
这篇关于无法使用SQL Server Management Studio连接到SQL Azure的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
