Configure Active Directory Service Principal Auth for Connectivity with MS SQL Server

Active Directory Service Principal Auth is only available for establishing connectivity with MS SQL Server JDBC driver. This article details how to obtain AD Service Principal Secret.

1. Register an Application

Access Azure Portal's Home

  1. Select App registrations
  2. Proceed with New registration
  1. Input a descriptive phrase in Name
  2. Specify Supported account types 
  3. [Register]

2. Locate Client ID

Access the newly-created application > Overview Tab

  1. Find Application ID to be used as Client ID in MI as shown on the screen above

3. Add Client Secret

  1. [+New client secret]
  2. Enter Description
  3. Specify validity period
  4. [Add]
  5. Copy the Client secret Value to be used as Secret in MI