Azure的SQL Server防火墙的IP地址范围 [英] Azure SQL Server Firewall IP address range

问题描述

从Azure中的MySQL迁移到SQL Server的我需要指定一个IP地址范围，可以访问数据库。

会为255.255.255.255的范围0.0.0.0即可进入？是否有一个IP地址范围，这将使我的'允许所有的。它不是实际的，我知道的请求将现身，并不断更新数据库防火墙规则。

解决方案

  

会为255.255.255.255的范围0.0.0.0即可进入？是否有一个IP地址范围，这将使我的'允许所有的。它不是实际的，我知道的请求将现身，并不断更新数据库防火墙规则。

是的，但肯定是不推荐这会给从每一个IP地址访问到您的SQL Azure数据库。当你提到，你不从那里您会收到请求知道，你的意思是请求您的应用程序或连接到数据库的请求？如果是请求您的应用程序，你并不真的需要指定这个范围内。你可以指定0.0.0.0，这将允许在Windows Azure上运行你的应用程序来访问这个数据库。

Moving from Azure MySQL to SQL Server I'm required to specify a range of IP addresses that can access the Db.

Will a range of 0.0.0.0 to 255.255.255.255 be OK to enter? Is there a range of IP addresses that will give me an 'Allow All'. Its not practical for me know where requests will be coming from and be constantly updating the Database firewall rules.

解决方案

Will a range of 0.0.0.0 to 255.255.255.255 be OK to enter? Is there a range of IP addresses that will give me an 'Allow All'. Its not practical for me know where requests will be coming from and be constantly updating the Database firewall rules.

Yes, this will give access to your SQL Azure databases from every IP address though it is certainly not recommended. When you mentioned that you don't know from where you'll receive requests, do you mean requests to your application or the request to connect to the database? If it is requests to your application, you don't really need to specify this range. You can just specify 0.0.0.0 which will allow your application running in Windows Azure to access this database.

这篇关于Azure的SQL Server防火墙的IP地址范围的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！