Connecting to SQL Server resources via Java JDBC using Azure Active Directory - Universal with MFA Support

Sreenivasa 0

I am currently working on a Java project and need to establish a connection to SQL Server resources using Azure Active Directory with Universal authentication that supports Multi-Factor Authentication (MFA). I have been searching for a solution, but haven't found a comprehensive guide for this specific setup.

Could someone please assist me in achieving the required result or provide step-by-step instructions on how to connect to SQL Server resources via Java JDBC using Azure Active Directory - Universal with MFA support? Any code examples, configurations, or best practices would be greatly appreciated. Thank you!

Sreenivasa 0 Reputation points

2023-07-19T08:59:05.16+00:00

Hi Shakti,

Thanks for your prompt response to this query.

ActiveDirectoryPassword authentication mode works well, but the client I'm building this for isn't ready/okay to enter his password due to their company policies. He's expecting to have the implementation without the need for the password. Please suggest!
ShaktiSingh-MSFT 16,241 Reputation points

2023-07-21T14:29:09.8166667+00:00

Hi Sreenivasa •,

Thanks for the reply.

Could you please explain more on the steps you are doing for Connecting to SQL Server resources via Java JDBC using Azure Active Directory.

Also, if you tried Azure Key Vault and then use in code?

Awaiting you reply. Thanks
Sreenivasa 0 Reputation points

2023-07-27T14:19:23.23+00:00

Hi Shakti,

Thanks for your response. I tried the steps provided in the below-shared article:

https://learn.microsoft.com/en-us/sql/connect/jdbc/connecting-using-azure-active-directory-authentication?view=sql-server-ver16

**ActiveDirectoryPassword is working for me

However, I did not try the Azure Key Vault method yet. Is there an article I can refer to for implementing this method?

Thanks!
Sreenivasa 0 Reputation points

2023-07-28T10:52:38.24+00:00

Thanks, let me try this and update you on the progress.
PRADEEPCHEEKATLA 90,541 Reputation points

2023-07-31T12:33:13.5333333+00:00

@Sreenivasa - We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

2 answers

ShaktiSingh-MSFT 16,241 Reputation points

2023-07-19T07:50:31.6933333+00:00

Hi Sreenivasa •,

Welcome to Microsoft Q&A forum and thanks for using Azure Services.

As I understand, you want a guide for Connecting to SQL Server resources via Java JDBC using Azure Active Directory - Universal with MFA Support.

Could you please refer to the document here https://learn.microsoft.com/en-us/sql/connect/jdbc/connecting-using-azure-active-directory-authentication?view=sql-server-ver16.

Do let us know if you face any issue in pefrorming the steps.

Thank you.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
ShaktiSingh-MSFT 16,241 Reputation points

2023-07-28T04:16:04.6+00:00

Hi Sreenivasa •,

Refer to https://learn.microsoft.com/en-us/sql/connect/jdbc/azure-key-vault-sample-version-9.2?view=sql-server-ver16#sample-application-using-azure-key-vault

Thanks
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Connecting to SQL Server resources via Java JDBC using Azure Active Directory - Universal with MFA Support

2 answers

Your answer