Change SQL ID connection to Azure AD

bukkybu 326 Reputation points

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.

Azure Active Directory
Azure Active Directory
An Azure enterprise identity service that provides single sign-on and multi-factor authentication.
14,736 questions
Azure SQL Database
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Cesar Lopez 75 Reputation points

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

    User's image

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

    0 comments No comments

  2. Alberto Morillo 27,781 Reputation points MVP

    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.

    0 comments No comments