-
Goal: Connect to an Azure SQL Managed Instance (SMI) leveraging Azure AD authentication (ActiveDirectoryPassword)
-
Steps: Created a new MSSQL resource, entered in the host, port, username, password, and tested the connection.
-
Details: Azure provides a list of connection string options to support different authentication types so I have taken the values out of the connection string and placed them in the appropriate places in the resource form.
Eg Use SSL/TLS ... full verification... Connection options
Authentication: ActiveDirectoryPassword -
Screenshots:
1 Like