Can I access azure sql server database without setting any clientIP address?

Kalpesh Dave 1

Can I access azure sql server database without setting any ClientIP address?
Bcoz my client ip address not fixed, They can access my azure sql server any system & using some time mobile data & wifi.

Anurag Sharma 17,606 Reputation points

2021-02-09T04:48:56.563+00:00

Hi @Kalpesh Dave , just wanted to follow up on the thread. If answer provided by @Nandan Hegde , you can mark it as 'Accept Answer'
Nandan Hegde 32,991 Reputation points MVP

2021-02-12T08:42:43.397+00:00

Hey @Kalpesh Dave
Did this answer your query ?
If yes, you can mark it as 'Accept Answer' as this would be beneficial for the community

1 answer

Nandan Hegde 32,991 Reputation points MVP

2021-02-02T06:20:30.847+00:00

Hey @Kalpesh Dave ,
You need to whitelist the entire range in firewall rule :
0. 0.0.0 to 255.255.255.255 for that scenario.
Then any way who has access can access from any IP and any location.
Please sign in to rate this answer.

7 people found this answer helpful.
Nandan Hegde 32,991 Reputation points MVP

2021-02-03T07:59:28.163+00:00

Hey @Kalpesh Dave ,
Did this answer your query ?
If yes, can you please mark it as answer so that it would be beneficial for other community members

anil kumar 1,646 Reputation points

2021-02-15T10:36:53.147+00:00

Thank you @Nandan Hegde for innovative solution. A bit risky from security point of view, still makes perfect sense.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Can I access azure sql server database without setting any clientIP address?

1 answer

Your answer