Access Azure SQL databases with Azure Identity instead of user/password

💬 Queries and Resources
1

Because of compliance and security reasons, we can't user user/password or connection string to connect to our Azure SQL databases.

Is it possible to use an Azure Identity to access the database?
And if yes, how?

Our Retool instance is self hosted, we have a vm and use docker-compose. We already have a System Assigned Identity for this virtual machine which could be used.

3

Hi @paulwellnerbou,

If your org is on an enterprise plan this can definitely be done!

Correct me if I am wrong but it seems that Azure Identity has been relabeled to "Microsoft Entra ID". Here is a link to our docs on how to set this up with a Retool.

There are also docs in that same section for SAML set up as well. Hope this helps!