'ODBC Connection to Azure SQL Database

I have an MS-Access database that links to an Azure SQL Database. I recently migrated a user from Hybrid to cloud-only and now he is unable to connect. When I set up the ODBC I get the following error.

ODBC Connection Error

I have tried all the azure authentication options with the same error.

I do have a cloud user that can connect just fine, but he was created within Azure as a cloud account.

  • Reinstalled ODBC 17 driver
  • auto-pilot reset the machine

any other ideas? I opened a ticket with MS also.

azureodbcazure-sql-database


Solution 1:[1]

An error may appear when trying to login to Azure SQL DB using AAD authentication.

This error means the user is invalid, usually related to a AAD user that does not have user created on SQL DB that you are trying to connect (User DB or Master DB) or that the user is not the AAD Server Admin.

You just need to add an AAD user in Azure SQL DB. You can follow the steps mentioned here: Create contained users mapped to Azure AD identities

Since you are connecting from SSMS you may also need to change the default database option. By default, it will try to connect to master DB where this user may not exist there as AAD users are contained inside each user database.

Need more information refer this document

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 PratikLad-MT

Related Questions