Access SQL Server on Azure VM via SQL Server Management Studio on my local Machine

Question

I'm sure this is out there somewhere but I can't find it and my brain hurts.

I have a VM on Azure. It has SQL Server running on it. I can access it locally on the VM no problem but I would like to manage it from my dev computer via SQL Server Management Studio.

Is this possible and what creds would I use? the VM Login?

Thanks, R

Answer 1

You need to complete all of the following to achieve what you want:

• 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.