Share via

Best ptractices for remote employees to access Azure SQL from SSMS/Data Studio

Max Baroi 0 Reputation points
2023-12-03T07:05:04.8233333+00:00

So currently I have a test Azure SQL database setup. I setup up with public network access disabled. Today I changed it to "selected networks", and added my client's IP address so I could make sure that I could access the database from SSMS running on my local machine. And that all works fine.

But what are the best practices to securely provide employees database access when they are working remotely or they don't have static IP addresses? Looking around a bit it seems point to site (P2S) is an approach, but I am getting some results for ExpressRoute.

I know this question is a little open ended but any recommendations or resources would be appreciated.

Azure SQL Database
Azure Data Studio
Azure Data Studio
A cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
118 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Andreas Baumgarten 111.1K Reputation points MVP
    2023-12-03T09:05:37.8566667+00:00

    Hi @Max Baroi ,

    the easiest option in my opinion is to use Endpoints for Azure SQL databases connecting to an Azure virtual network/subnet. To connect an on-premises network it's possible to deploy a VPN Gateway with Site-To-Site connections or Azure Express Route and for individual remote access for single connections the use of a Azure VPN Gateway Point-To-Site deployment.

    (If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

    Regards

    Andreas Baumgarten

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.