Azure-docs: Query thru Service principal

[Ayanmullick]

Will this work for a Service Principal or for an MFA-enabled user?

---

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

• ID: 476e6b04-34c2-0502-7f00-4f89b24fc475
• Version Independent ID: f0b07c53-8175-6b83-f66f-ab69f8c5313b
• Content: Use Java to query Azure SQL Database
• Content Source: articles/sql-database/sql-database-connect-query-java.md
• Service: sql-database
• GitHub Login: @ajlam
• Microsoft Alias: andrela

[cheenamalhotra]

Hi @Ayanmullick

Azure Active Directory authentication for MFA-enabled user is not supported with MSSQL JDBC Driver.

You can find samples and details on supported authentication modes with Azure here. If by Service Principal you mean SPN as used in this example, it can be used to acquire access token which can be further used for authentication with JDBC Driver. You may notice Client ID and Client Secret required here are to be configured as explained here.

Furthermore if you can explain with a sample code what exactly are you trying to connect with, we can clarify better.

Thanks!

[Mike-Ubezzi-MSFT]

@Ayanmullick Thank you for the detailed inquiry. The Use Java to query Azure SQL Database uses SQL Authentication, but the following document walks you through Azure Active Directory Authentication with Azure SQL Database using a Java client and all supported Auth types: Connecting using Azure Active Directory Authentication

• Connecting using ActiveDirectoryMSI Authentication Mode
• Connecting using ActiveDirectoryIntegrated Authentication Mode
• Connecting using ActiveDirectoryPassword Authentication Mode
• Connecting using Access Token

Please let me know if you have any additional questions. The above document is specific to AAD.

[Ayanmullick]

@cheenamalhotra , for sharing the link. In my opinion, that link should be added to the Next Steps section of this document.

please-close