AAD authentication for Azure SQL Database deployment task

Question

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?

Answer 1

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

Answer 2

Hey,

For AAD authentication, you need to enabled AAD auth:

Ref :

https://www.mssqltips.com/sqlservertip/6751/azure-ad-authentication-azure-sql-databases/

Once AAD auth is established, you can use Service principal auth as well which is AAD linked:

https://datasharkx.wordpress.com/2021/03/11/automated-deployment-of-azure-sql-database-azure-sql-data-warehouse-through-azure-devops-via-service-principal-part-1/

https://datasharkx.wordpress.com/2021/03/12/automated-deployment-of-azure-sql-database-azure-sql-data-warehouse-through-azure-devops-via-service-principal-part-2/