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

andyvidanandyvidan
in Modules and DataFlows

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
image.png
  • Enter the required fields as follows
image.png
  • Create the following Key-Value Parameters:
  1. (Authentication, Active Directory Password)
  2. (Data Source, tcp:xxxxxxx.database.windows.net)
image.png


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

image.png


Sign In or Register to comment.

© Vanilla Keystone Theme 2023