Change SQL ID connection to Azure AD

Question

I have an on prem windows desktop app with an azure sql database backend. The connection is currently being made via sql ID in an ini file on prem. I need to change the connection to authenticate against Azure AD. A windows account is ready with perms on the Azure SQL database. The app has been registered in the Azure portal. My Azure experience is very limited, so any assistance is greatly appreciated.

Answer 1

If you need a account, it is posible. But you should use a Azure Key Vault and rotate user´s passwords.

This examples is for a storage account, but SQL is too funcionality

Answer 2

Here you will find how connection strings are changed to connect using ADD that I hope may help you make the appropriate changes on the .ini file.

To use Azure AD authentication, you must configure your Azure SQL data source as explained here.