Access SQL Server on Azure VM via SQL Server Management Studio

Question

I have an SQL Server running on my Azure VM. I can access it locally, but I would like to manage it from my Dev computer via SQL Server Management Studio.

Is this possible? If yes, then what credentials would I use?

Answer 1

Following these steps might help you:

• Add a TCP endpoint for that VM on port 1433 - public & private (you can change the public port if you will).
• Configure the SQL Server Instance to listen to TCP.
• Enable the incomping TCP port 1433 in the local FireWall rules of the VM.
• Enable mixed mode authentication on the SQL Server
• Make sure your ISP does not block outgoing port 1433 (a common practice for most of ISVs since 2003' SQL Slammer) - this is overridable with custom Public port for your TCP endpoint.

Than you will be able to connect to the SQL Server in the Azure VM using your local SSMS.