question

31djpar avatar image
31djpar asked

Is it possible to connect to an Azure SQL Database from within Azure itself (ie NOT via SSMS through a firewall)

I would like to create an Azure SQL Database and be able to query it only from within the Azure Resource Group to which it is assigned. We want to keep access to the data as locked down as possible. So, connecting to it via SSMS on my PC after setting up a firewall would not be an option. I had thought of Query Editor from within the Azure portal, but it seems that that too is accessing the database from my PC and requires a firewall to be put in place.

I suppose I could create a virtual machine with SQL Server and SSMS installed, but that seems like overkill.

Does anyone have any suggestions?

Many Thanks

ssmsazureazure sql db
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.