Windows Azure的客户端IP地址为“XXX.XXX.XXX.XX'是不允许访问该服务器 [英] Windows Azure Client with IP address 'XXX.XXX.XXX.XX' is not allowed to access the server

问题描述

我已经安装Sever的，数据库，防火墙设置（规则）在Windows Azure中。我已经添加了IP在其下的Windows Azure的防火墙选项卡填充防火墙设置。

I have setup Sever, database and Firewall Setting (Rule) In windows Azure. I Have added The IP In firewall setting which is populating under the Windows Azure Firewall Tab.

当我试图用管理来自Azure平台我收到此错误信息的数据库连接。

When I am trying connect with Database using Manage from Azure Platform I am getting this error message.

防火墙检查失败。无法打开服务器XXXXXXXXX登录所请求。 IP地址为XXXXXXXXX不允许客户端访问服务器。要启用访问，请使用SQL Azure的门户网站或主数据库上运行sp_set_firewall_rule创建此IP地址或地址范围内的防火墙规则。这可能需要长达五分钟，此更改生效。

和我也无法通过SQL Server Management Studio中进行连接。获得相同的连接问题，误差为我的IP地址。

And I am also Not able to connect via Sql Server Management Studio. Getting Same connection issue Error for My IP Address.

我不使用静态IP，但我的IP在这一过程中不会改变。我已经试过很多实例但都表示要添加防火墙规则，我已经做了。

I am not using static IP but my IP haven't change during this process. I have tried lot Example but all are saying To add firewall rule That I had already done.

我添加防火墙例外端口号1433。

I have Added Firewall exception for port Number 1433.

不过，这仍然不能正常工作，请让我知道还缺什么类型的设置。

But still this is not working Please let me know that what type of setting is still missing.

先谢谢了。

推荐答案

如果您想从Azure的门户网站管理SQL Azure中你必须选中允许其他Windows Azure服务连接到这台服务器。这也是以后需要部署到Azure的你的Web /辅助角色：

If you want to manage SQL Azure from the Azure Portal you have to check the "Allow other Windows Azure Services to connect to this server". That is also required later for your Web/Worker roles deployed to Azure:

如果您想从您的家庭/工作PC连接，你必须保持防火墙了最新的与你的公网IP​​地址！你的公网IP​​地址是在小的弹出窗口，它弹出时，要增加新的防火墙规则：

If you want to connect from your home/work PC, you have to keep the firewall up-to-date with your public IP address! Your public IP Address is in the little popup windows, which pops out when you want to add new firewall rule:

这篇关于Windows Azure的客户端IP地址为“XXX.XXX.XXX.XX'是不允许访问该服务器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！