How to connect the Azure SQL DB Managed Instance using Azure AD User Account.

Steps to connect Azure SQL DB Managed Instance using Azure AD User account.

---

Step 1: Log into the Windows Jump Server using Remote Desktop

Enter the Username and Password

Step 2: Search for the SSMS Console after logging into the Windows Jump Server.

Step 3: Enter the Server name and select the Authentication Type as

“Active Directory – Universal with MFA support”

Make sure before connecting, the AD Domain name or tenant ID checkbox and enter your Azure Domain Name “sampledomain.onmicrosoft.com”

Step 4: Enter your Username to login

Step 5: Enter your Password to connect to the Azure SQL Managed Instance.

Now the connection to the Azure SQL Managed Instance succeeded.

Select “New Query” windows and write your query in the selected database and execute to get the data.

---

End of Document