Connection to Azure SQL Server database error - IMPORTANT

Peter_Yates
Participant II

Guys, I have been working on an Azure SQL Server Database POC quite happily for last 3 days. This morning Australia time ( Saturday ) I am not able to connect do as it tells me the firewall rules need to be set-up. I have already been working and donโ€™t know what is going on. Do I need to list every one of the IP Addressโ€™s in your firewall list. If this is the case it is totally unmanageable.

I have the first one already in my firewall client access rules and it has been working fine.

Available IP Addresses:

20.189.130.98

Please get back to me ASAP.

Peter

0 3 324
3 REPLIES 3

You have to put all the listed IP address on the Azure SQL fire wall permitted list.

Short cut to the proper docs you can find on this community as well.

Adding all the IP to firewall set is kinda of boring jobs, but we need to set them up. Suggest to do this type of jobs with a cup of tea beside.

Top Labels in this Space