Connecting to Azure Database SQL MI using Active Directory - Password for Authentication

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:

  • Select the Database Connection Settings type
  • Enter the required fields as follows
  • Create the following Key-Value Parameters:
  1. (Authentication, Active Directory Password)
  2. (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:


Sign In or Register to comment.