Zurück
-
Titel
App registration not letting user connect to Azure hosted SQL Server -
Beschreibung
After using the instructions listed in the KB article https://blog.apexsql.com/using-apexsql-tools-with-azure-active-directory-authentication/
When using MFA authentication method, the login process comes back as Unverified and does not connect to the Azure hosted SQL Server
-
Ursache
The App registration lacks of permissions necessary to allow connections to the Azure hosted SQL Server databases. -
Lösung
The App registration inside the Azure Active Directory needs to be changed to add the following API permissions:
- Azure SQL Server database
- user_impersonation
- Microsoft Graph
- offline_access
- openid
- profile
Once these permissions are added to the App registration, the application will authenticate and connect correctly to the Azure hosted SQL Server.
- Azure SQL Server database