AAD authentication for Azure SQL Database deployment task

Richard Barraclough 11 Reputation points
2023-01-30T13:40:27.5866667+00:00

User's image

Using the Azure SQL Database deployment task: is it possible to authenticate using AAD rather than SQL Server Authentication?

I turned on the managed identity on the Azure SQL Server but that didn't make it work. What do you have to do to set it up?

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,289 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. abdulaziz 86 Reputation points
    2023-01-30T15:11:48.95+00:00

    We can set up Azure Active Directory (Azure AD) authentication for SQL Server.

    To perform Azure AD authentication, SQL Server needs to be able to query Azure AD and requires an Azure AD app registration, which it can authenticate as. The app registration also needs a handful of permissions for the queries SQL Server will perform

    Check below link.

    https://learn.microsoft.com/en-us/sql/relational-databases/security/authentication-access/azure-ad-authentication-sql-server-setup-tutorial?view=sql-server-ver16

    0 comments No comments

  2. Nandan Hegde 34,171 Reputation points MVP
    2023-01-31T03:47:14.5966667+00:00
    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.