Azure Database Access - Firewall Issue

Question

As a team, we are working on a project whose database is hosted on Azure . Since I have an Azure management portal , I am adding my IP address to the management portal. I cannot add other IP addresses to my team members every time.

Is there a way to access Database hosted in azurewithout adding an IP address every time?

Answer 1

You need to specify which IP addresses or IP ranges have access to your database. If your IP addresses change dynamically and often, it’s best to add a range of IP addresses on the portal.

https://azure.microsoft.com/en-us/documentation/articles/sql-database-configure-firewall-settings/

- IP- ( 0.0.0 255.255.255.255). , , IP- , . - IP-, . .

Answer 2

, () .azure.com, , , : ( Azure SQL), powershell.

Answer 3

Microsoft, , Azure . . , SQL, Essentials , "... " " ". ​​ , IP, IP- IP-, , IP-, IP- IP- .

Answer 4

It is true that resolving the entire range of IP addresses (from 0.0.0 to 255.255.255.255) will allow someone to try to access your database. Although if you configured password authentication for the Azure Active Directory, you still need a valid username and password to connect to SQL Server.