SpringBoot on premise app connection to Azure SQL DB using Entra ID authentication

Gaurav Rana 0 Reputation points
2024-01-17T12:48:48+00:00

Hi, I have a spring boot app deployed in docker swarm on premise.
I want to connect it to Azure SQL database using Microsoft Entra ID authentication methods. I have achieved connectivity using the access token method, as outlined in the documentation: https://learn.microsoft.com/en-us/sql/connect/jdbc/connecting-using-azure-active-directory-authentication?view=sql-server-ver16#connect-using-access-token However, I am interested in exploring alternative authentication methods that may be more suitable for connecting an on-premise Spring Boot application to an Azure SQL database. Many of the documented methods appear to assume the deployment of the Spring application to Azure. Thanks.

Azure SQL Database
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
23,257 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Carlos Solís Salazar 18,086 Reputation points MVP
    2024-01-17T12:54:50.3333333+00:00

    For connecting your on-premise Spring Boot application to Azure SQL Database using Microsoft Entra ID authentication, there are several methods besides the access token method that you've already implemented. Here are some alternatives:

    Each method has its own set of pros and cons, and the best choice depends on your specific requirements, such as the level of security needed, ease of implementation, and the infrastructure already in place. If you need further assistance or specific guidance on any of these methods, feel free to ask.

    Lastly, if you find this information helpful, please consider accepting the answer.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.