Access SQL Server on Azure VM via SQL Server Management Studio

0 votes
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?
Apr 10, 2019 in Azure by sabby
• 4,370 points
1,500 views

1 answer to this question.

0 votes

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.

answered Apr 10, 2019 by Prerna
• 1,960 points

Related Questions In Azure

+2 votes
2 answers

Access denied: Root login Ubuntu VM on Azure

I have the same issue. Any help? READ MORE

answered Sep 27, 2018 in Azure by anonymous
3,644 views
+1 vote
1 answer

How to copy Azure SQL database to a local development server?

Actually, there are multiple ways to do ...READ MORE

answered Jul 9, 2018 in Azure by null_void
• 3,220 points
2,644 views
0 votes
1 answer

How can I copy SQL Azure database to a local development server?

There are certain ways to do this: Using SSIS ...READ MORE

answered Jun 26, 2018 in Azure by null_void
• 3,220 points
1,195 views
0 votes
2 answers

How to restore SQL Server .bak file to Azure SQL Database?

To restore SQL Server .bak file you ...READ MORE

answered May 28, 2019 in Azure by sherry
• 140 points
33,651 views
0 votes
1 answer

How to install Windows Azure Storage Emulator?

There may be an issue with the ...READ MORE

answered Mar 7, 2019 in Azure by Prerna
• 1,960 points
2,825 views
0 votes
1 answer

Azure Storage Emulator shows error.

Check if you are running BitTorrent/uTorrent or similar ...READ MORE

answered Mar 16, 2019 in Azure by Prerna
• 1,960 points
1,734 views
0 votes
1 answer

Friendly filename when downloading Azure blob.

Azure blobs can be downloaded in four ...READ MORE

answered Mar 16, 2019 in Azure by Prerna
• 1,960 points
3,800 views
0 votes
1 answer

How to debug Azure 500 internal server error?

You can simply turn off custom error in ...READ MORE

answered Mar 29, 2019 in Azure by Prerna
• 1,960 points
4,861 views
0 votes
1 answer

How to query between databases in SQL Azure Database Server?

SQL Azure supports cross database queries: https://azure.microsoft.com/en-us/blog/querying-remote-databases-in-azure-sql-db/ Hope this ...READ MORE

answered Apr 9, 2019 in Azure by Prerna
• 1,960 points
13,042 views
0 votes
1 answer

How do disconnect to Azure SQL database if I can't access it?

Based on info  from Microsoft, I think ...READ MORE

answered Apr 26, 2019 in Azure by Prerna
• 1,960 points
1,362 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP