Share via

Accessing Azure Database without Azure Virtual Machine

Tim Zuspan 5 Reputation points
2023-12-03T02:31:10.87+00:00

Is it possible to access an Azure database from your personal computer without going through an Azure virtual machine? If so, what method do you use?

Azure SQL Database
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Alberto Morillo 34,671 Reputation points MVP Volunteer Moderator
    2023-12-03T04:11:40.01+00:00

    You can download and install SQL Server Management Studio (SSMS) on your personal computer and the use it to connect to your Azure SQL Database. Please follow the steps provided on this documentation.

    SSMS should help you register your public IPv4 address on Azure SQL firewall but if SSMS does not get connected make sure your public IP address has been added as a rule on the Azure SQL firewall as explained here.

    0 comments
  2. RahulRandive 10,486 Reputation points Volunteer Moderator
    2023-12-04T13:21:28.13+00:00

    Hi @Tim Zuspan

    Besides SSMS, if you prefer to connect directly to the database and run queries, you can also do so through Query Editor in the Azure portal

    User's image

    Thank you!

    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.