How to Authenticate Azure SQL Server Database from Azure Web Apps

Bina Trivedi 6

Hii,
I am Deploying my Spring boot application from Azure DevOps Pipeline into the Azure windows web app,
my spring boot application requires a connection with the Azure SQL Database,
Please suggest how I can connect with the azure SQL database from the web app using Azure Active Directory Authentication.
do I need to do any configuration while creating the azure DevOps pipeline during deployment, or any configuration in the azure web app?

Lex Li (Microsoft) 5,392 Reputation points Microsoft Employee

2022-10-14T05:16:14.213+00:00

You can get started from https://learn.microsoft.com/en-us/azure/azure-sql/database/connect-query-java?view=azuresql
Bina Trivedi 6 Reputation points

2022-10-14T07:51:57.48+00:00

Hi,
we are trying to connect with the azure active directory Interactive Authentication Method(MFA) using the spring boot application to Azure SQL Database from the Azure DevOps and Azure Web app.
Our Build and Release are Successful, but we are not able to run the application, it gives a Service not available error.
do we require to change anything in the configuration file of the web app or while creating an azure DevOps pipeline?
Following properties we are giving for the Azure SQL Server authentication using mfa:

****spring.Datasource.username=Azure Portal login Username
spring.datasource.hikari.data-source-properties.authentication = AzureActiveDirectoryInteractive
spring.datasource.url=jdbc:sqlserver://servername.database.windows.net:1433;database=databasename;encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;loginTimeout=30****

By using these properties we try to connect to azure SQL database from our localhost and we are able to connect successfully , now we are trying to connect azure SQL database from azure devops and azure webapp but we are getting error as service is not available.

1 answer

Andriy Bilous 11,176 Reputation points MVP

2022-10-14T06:03:12.96+00:00
Hello @Bina Trivedi

I would recommend you to use Azure SQL Database Passwordless Connections as this is the most secured way for DB connection.
There are simple configurations steps in Azure SQL and Azure App Service:

Enable Azure AD authentication with Azure SQL

Activate the Managed Identity

Create the database user for the created Managed Identity

Assign permissions in Azure SQL for a user

Use Azure.Identity in Java code
Please sign in to rate this answer.
GeethaThatipatri-MSFT 29,017 Reputation points Microsoft Employee

2022-10-28T15:54:49.247+00:00

@Bina Trivedi We haven't heard back from you. Just wanted to check if you find the above reply useful. If yes, do click on the 'Mark as answer' link in the above reply. This will help other community members facing similar queries to refer to this solution.

Regards
Geetha
Sign in to comment

Share via

How to Authenticate Azure SQL Server Database from Azure Web Apps

1 answer