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:
- (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: