Change SQL ID connection to Azure AD

bukkybu 326 Reputation points
2023-05-23T19:49:05.7833333+00:00

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

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Cesar Lopez 75 Reputation points
    2023-05-23T20:20:38.2333333+00:00

    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
  2. Alberto Morillo 27,781 Reputation points MVP
    2023-05-23T20:25:52.99+00:00

    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