Azure SQL Managed Instances / SSMS / Connect to SQL Managed Instance / Public Endpoint

Posted by in Azure, SQL Server, SQL Tips and Tricks on Sep 5th, 2019 | 0 comments

In the previous post we had example how to connect to Azure SQL Managed Instance from Azure VM within same VNet using private endpoint

Azure SQL Managed Instances / SSMS / Connect to SQL Managed Instance / Private Endpoint

Now I will show you how to connect to the SQL Managed Instance from your remote location using public endpoint.

First go to your SQL MI and select Virtual Network 

 

Enable Public Endpoint (data) option

Public endpoint provides the ability to connect to Managed Instance from the Internet without using VPN and is for data communication (TDS) only.

 

After enabling your SQL MI will have 2 connection strings, private and public

For the remote access via public endpoint you will need to open port 3342 for inbound traffic. To do that you need to configure Network Security Group rule for this port.

I would recommend to limit access to the managed instance public endpoint on port 3342 and use well-known IP addresses as a source.

To connect use your admin credentials and public server name from public endpoint connection string following with the port number 3342

Similar Posts:

Leave a Reply

Your email address will not be published. Required fields are marked *