question

03901057 avatar image
0 Votes"
03901057 asked AnuragSharma-08 edited

do we have to set firewall rule every time we connect microsoft azure sql database to ssms

whenever I have to use SSMS I have to add client IP address in azure. Is there any way available to use SSMS without adding public IP every time?

azure-sql-database
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

AnuragSharma-08 avatar image
0 Votes"
AnuragSharma-08 answered AnuragSharma-08 edited

Hi @HarshitaVerma-1359, welcome to Microsoft Q&A forum.

Firewall rules are there to protect unauthorized access to the Azure SQL Server and only the permitted IPs will be able to access the server and its recommended as well.

However we can whitelist all the IPs that are connecting to Azure SQL. In this case you don't need to add IPs again and again. Refer to below screenshot on how to configure this:

204291-image.png

Please let us know if this helps or else we can discuss further.



If answer helps, please mark it 204216-image.png





image.png (71.1 KiB)
image.png (5.6 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.