I'm trying to connect to a SQL Server database that's being hosted on Azure, I'm using the server explorer to select my Azure account, then the SQL Server; I right click and select "Open in SQL Server Object Explorer" after which I'm prompted to enter the password.
我正在尝试连接到Azure上托管的SQL Server数据库,我正在使用服务器资源管理器选择我的Azure帐户,然后选择SQL Server;我右键单击并选择“在SQL Server对象资源管理器中打开”,然后提示我输入密码。
I'm unable to go past this step as I've been getting this error (see screenshot) ever since creating the server. I've added my IP address to the SQL Server's firewall.
自从创建服务器以来我一直在收到此错误(请参见屏幕截图),我无法通过此步骤。我已将我的IP地址添加到SQL Server的防火墙中。
I've even tried connecting to it with my firewall off but I get the same error.
我甚至尝试在关闭防火墙的情况下连接它,但是我得到了同样的错误。
2 个解决方案
#1
1
I managed to fix the problem, it turns out the network(eduroam) at my university was the problem. I don’t understand how or why they’d want to block Azure; but using a proxy or a mobile hotspot connects me immediately without any errors.
Thanks you all for trying to help.
我设法解决了这个问题,事实证明我大学的网络(eduroam)是问题所在。我不明白他们想要阻止Azure的方式或原因;但是使用代理或移动热点可以立即连接我而不会出现任何错误。谢谢大家的帮助。
#2
0
You can open Visual Studio from within Azure Portal and you will be automatically connected to your Azure databases. Please see image below.
您可以从Azure门户中打开Visual Studio,您将自动连接到Azure数据库。请看下面的图片。
#1
1
I managed to fix the problem, it turns out the network(eduroam) at my university was the problem. I don’t understand how or why they’d want to block Azure; but using a proxy or a mobile hotspot connects me immediately without any errors.
Thanks you all for trying to help.
我设法解决了这个问题,事实证明我大学的网络(eduroam)是问题所在。我不明白他们想要阻止Azure的方式或原因;但是使用代理或移动热点可以立即连接我而不会出现任何错误。谢谢大家的帮助。
#2
0
You can open Visual Studio from within Azure Portal and you will be automatically connected to your Azure databases. Please see image below.
您可以从Azure门户中打开Visual Studio,您将自动连接到Azure数据库。请看下面的图片。