Connect Azure Managed SQL Instance using SSMS

Well.. In Azure PaaS we have two options to create and manage SQL database

    1.Azure SQL database

    2.Azure Managed SQL Instance

In managed instance have capability to create and manage up to 100 databases.

Compared with Azure SQL database each DB has specific computing & storage, but in Managed instance common compute & storage for all DBs inside the Managed instance.

Azure managed instance is good for easy lift & shift migration from On-premise to Azure.

Easy to keep many databases as needed.

Creation of managed instance may take more than 4 to 32 hours in Azure.

Connect Azure Managed SQL instance using SSMS

1.Select the managed instance to configure allow connection from remote.

2.Click on Networking from left pane

3.Enable public endpoint and make note of port used to connect the managed instance. By default it is 3342

4.Go to overview page and select VPN network/subnet

5.Click on subnet tab from left panel

6. Note down the security group name

7.Go to Network security group service using Azure portal search.

8.Select the appropriate security group and select Inbound settings

9. Click on add new and provide below details.

10.Once added the details click save and try to connect from local SSMS using managed instance name and port number (3342). Use the below details to get instance details