AZURE SQL SERVER AND MANAGED IDENTITY | SQL Connection String Without Username and Password

Azure SQL supports Azure AD authentication, which means it also supports the Managed Identity feature of Azure AD. With Managed Identity, we no longer need the User Id and Password to connect. The credential is managed automatically by Azure and allows us to connect to resources that support Azure AD authentication.

In this video, let us look at how we can use Manage Identity to connect to Azure SQL from a web application running in Azure. Once set up, all we need is the database server name and the database name to connect to the database

Related blog post: https://www.rahulpnath.com/blog/azure...

Azure SDK DefaultAzureCredential : Unifying How We Get Azure AD Token -    • Azure SDK DefaultAzureCredential : Un...  
Azure Managed Identity and Local Development -    • Azure Managed Identity and Local Deve...  

Managed Identity and SQL Server - https://docs.microsoft.com/en-us/azur...
EF Core (First Class Support for Azure AD Token) https://github.com/dotnet/efcore/issu...

Image by Darwin Laganzon from Pixabay - https://pixabay.com/illustrations/hac...