在Visual Studio或SQL Server Management Studio中连接到Azure SQL数据库的哪些必要步骤? [英] Which are necessary steps to connect to an Azure SQL database in Visual Studio or SQL Server Management Studio?

问题描述

我将Visual Studio 2013与更新5配合使用.我在Azure上创建了一个SQL数据库.

I am using Visual Studio 2013 with update 5. I created a SQL database on Azure.

现在我正在尝试在VS和SQL Server Management Studio中连接到它，但出现此错误

Now I am trying to connect to it in VS and SQL Server Management Studio, but I get this error

错误:连接到服务器

Error : Connect to Server

无法连接到MyServerName.database.windows.net.

Cannot connect to MyServerName.database.windows.net.

其他信息:

建立与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)

找不到网络路径

在连接到Azure SQL之前，我已经执行了以下步骤:

Before connecting to Azure SQL I have taken these steps:

• 在SQL Azure防火墙中添加了计算机的IP
• 通过在本地计算机上的防火墙中添加新的出站规则来打开端口1433

我想知道整个过程中我缺少哪一步.

I want know which step I missing in whole process.

推荐答案

好.这很麻烦，因为您无法使用该地址访问.尝试通过IP连接，并确保您正在使用PUBLIC IP/DNS.尝试在两侧打开防火墙.这就是我为您所报告的信息错误所能提供的全部帮助.您正在使用的连接字符串不正确或无法访问.

Well. This is hapenning because tha address you're using isn't ok to access. Try to connect through the IP, and make sure you're using the PUBLIC IP/DNS. Try to open the firewall on both sides. That's all that I could help you with the information error reported for you. The conection string that you're using is not ok or not accessible.

这篇关于在Visual Studio或SQL Server Management Studio中连接到Azure SQL数据库的哪些必要步骤?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！