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

[howeizu]

Tutorial was very nice. How to validate the life time of a access token retrieved through Azure?

[sunpengjie]

This is the best video in regards to managed identity, so helpful.

[gauravjoshi]

Nice video Rahul thanks you. Quick question is it same as Entra authentication ..? I have to move my SQL servers access from UserName/Password to Entra authentication any suggestion please

[neonjay]

Very informative video. I also visited your blog and there are lots to learn there as well. Is the code to the entire solution available somewhere? Keep up the good work!

[amazdanny]

Brilliant! Would love to watch more videos, thank you

[Ranjittgs]

Thank you soooo much Rahul for providing Azure content for free. Very very useful for me🙏🙏🙏

[slotslights]

Thanks RahulNath, it was easy explanation of Managed identity.

[seanwauchope]

Hi Rahul, great tutorial. I followed this and was able to connect. One issue is that the token expires after a certain time. How would you refresh the token automatically?

[swapnilgadge]

Thanks for awesome videos. Just one suggestion "Kadi has bhi liya karo" :)

[shivakumar-lcif]

Very Helpful, Informative and straight to the Point. Thank you for the awesome video. Also Rahul, can you also please let know, do we still need the AD user added in the Azure Admin, after granting the 'App Service' Read-write permissions in the SQL. I tried after removing the AD user, application is not connecting to SQL from Azure hosted (It is working with the User in AD). It will be great if you could help understand what is happening under the hood. Thanks Again.

[mohammedmus-abbelgami]

Hi Rahul,
I have deployed Node.js app in WebApp and trying to connect sql DB and WebApp using MSI behind private endpoints
I have enabled the MSI and granted WebApp access to SQL DB.
Local setup seems to be working fine however I am encountering 500 internal error when hosted on WebApp
any inputs?

[minhcdao]

Hi Rahul, is it possible to get accessToken for Azure SQL DB using from the current authenticated user (after OpenID login) on the server? It's double-hop use case. Thanks.

[pankajutubepankaj]

@Rahul Nath, learned a lot from your videos. I have a query. How to achieve passwordless connection string in .Net worker process. I want to deploy .net core 5 windows service to multiple VMs. The service does some Azure DB related work. Is it possible to have passwordless connection string in this scenario?

[damma]

Awesome tutorial !!. You are a life saver man. Thank you so much!

[Sergio-Here-In-Community]

Very good, demo of how to configure things, I like very much hand on that help see how things works, not just theory.
thanks I subscribed to your channel and I will see your your videos.
thanks for it.

[fahadmuhammad]

I followed all the steps, i did got token but facing this exception when try to connect to Sql Server => SqlException: Login failed for user ''. The server is not currently configured to accept this token.

[bmrreddy]

Hey Rahul, is the App Service IP whitelisting required? If MSI is enabled, can we just add that identity on the SQL server with certain roles?

[mekarthikktk]

Hello Rahul, Were will I get the credential for the AD Password Authentication, When we grant acees to function app ?

[deepakmitawa]

really enjoying your videos to learning. keep it up

[swapnarenukunta]

The best video. Thank you so much Rahul