无法连接到Windows Azure数据库 [英] Can't connect to Windows Azure Database
问题描述
我正在尝试通过Visual Studio连接到Windows Azure数据库
I am trying to connect to a windows azure database through visual studio
这是我的步骤:
- 我在服务器浏览器中按添加连接
- 填写服务器名称.database.windows.net
- 选择使用SQL Server身份验证
- 填写用户名和密码
- 输入数据库名称
当我按OK时,我必须等待一段时间,然后显示错误40:无法连接到sql server.
When I press Ok, I have to wait some time and then it gives and error 40: could not connect to sql server.
我的Azure服务器设置为接受(0.0.0.0-255.255.255.255)中的IP,MicrosoftServices也是如此,有人可以帮助我吗?我真的很困惑,我已经尝试过所有我想起的:(
My Azure server is set to accept ip from (0.0.0.0 - 255.255.255.255) and so is the MicrosoftServices, can someone please help me with this? I'm really stuck, I've tried about everything I could think of :(
我正在关注本教程:在第7步卡住了...
Got stuck at step 7...
推荐答案
您需要运行SQL Server 2008 R2(+ Service Pack)才能通过SSMS(SQL Server Mgmt Studio)进行连接
You need to be running SQL Server 2008 R2 (+ Service Packs) to connect via SSMS (SQL Server Mgmt Studio)
这篇关于无法连接到Windows Azure数据库的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!