How do I set up a Key to access SQL Managed Instance (Azure SQL MI)

[data-usr]

How do I set up a Key to access SQL Managed Instance (Azure SQL MI) using Active Directory Authentication?

[andyvidan]

When using Azure Database SQL MI (SQL Managed Instance), your Composable Key will need to specify that it should use Active Directory - Password for Authentication. This requires adding two Key-Value Parameters to your Composable Key.

Set up your Composable Key as follows:

1. Select the Database Connection Settings type

3. Enter the required fields as follows

4. Create the following Key-Value Parameters:

• (Authentication, Active Directory Password)
• (Data Source, tcp:xxxxxxx.database.windows.net)
  

With the Key set up in this way, you can then access Azure SQL MI using the usual modules, as follows: