How to use SSMS to connect to a SQL db without firewall rule?

Question

I'm aware of the Microsoft documentation here. And have created both server-level and database-level firewall rules for accessing an Azure SQL db.

I'm now at a coffee shop using SQL Server Mgmt. Studio to work on an Azure SQL db, but DO NOT want to accept the coffee shop's IP address as a whitelisted IP.

How can I access my Azure SQL Server without whitelisting every IP address I wish to connect from? Is there some type of Azure proxy to use?

Thank you

You can automate updating the same firewall rule by just running a PowerShell script. Let me know if you want me to share with you a sample script. — Alberto Morillo
– Alberto Morillo, Commented Oct 7, 2018 at 19:41

Rohit Saigal · Accepted Answer · 2018-10-07 18:42:02Z

2

Short answer is that you can not connect from an IP address that isn’t whitelisted.

AFAIK, there isn’t a proxy available for such scenario.

As a workaround,

you can add and remove the IP from whitelist later or
have a VM (on Azure or elsewhere) with SSMS that is able to connect to your DB and you could remote into that.

answered Oct 7, 2018 at 18:42

Rohit Saigal

9,7622 gold badges25 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

SeaDude · Accepted Answer · 2018-10-12 04:12:18Z

1

Thanks for the offer @AlbertoMorillo. I decided to go with:

curl ifconfig.me to determine IP address, then

EXECUTE sp_set_database_firewall_rule @name = N'name_your_rule', @start_ip_address = 'xxx.xxx.xxx.xxx', @end_ip_address = 'xxx.xxx.xxx.xxx'

to create the rule, then

EXECUTE sp_delete_database_firewall_rule N'name_your_rule'; when I'm finished.

answered Oct 12, 2018 at 4:12

SeaDude

4,4869 gold badges50 silver badges94 bronze badges

Collectives™ on Stack Overflow

How to use SSMS to connect to a SQL db without firewall rule?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related