Share via

Migration Access Database to Azure SQL

Andres Esteban 156 Reputation points
2024-01-10T08:27:47.83+00:00

I am migrating an access database to Azure SQL following the procedure indicated in the following link: https://learn.microsoft.com/es-es/azure/azure-sql/migration-guides/database/access-to-sql-database-guide?view=azuresql and using the SQL Server Migration Assistant for Access tool (SSMA for Access) and the migration is done correctly.

The problem comes when I try to link the tables I get the following error: User's image

Does anyone know why this is happening to me if I have been able to connect without problems to make the migration? I am not authenticating with windows but with sql credentials, username and password.

Thank you

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,999 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
317 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaktiSingh-MSFT 14,091 Reputation points Microsoft Employee
    2024-01-10T08:44:22.9566667+00:00

    Hi Andres Esteban,

    Welcome to Microsoft Q&A forum.

    As I understand, you are performing Migration of SQL Server to Azure SQL Database using SSMA and getting error: windows logins are not supported in this version of sql server and is using SQL credentials.

    Could you please try to add: 

    Trusted_Connection=False;Encrypt=True;

    to your connection string and see if this helps.

    Also try to set:

    Integrated Security=False

    this might also help.

    Other helpful posts: https://stackoverflow.com/questions/64002224/ssms-windows-logins-are-not-supported-in-this-version-of-sql-server

    Let us know after trying above if issue resolve.

    Thanks

  2. Olaf Helper 42,286 Reputation points
    2024-01-10T08:45:57.46+00:00

    By the error message I would say, you try to use Windows Authentication (domain account) to logon Azure SQL database; that's not supported.

    You have to use a SQL Login or an Azure AD account for auth, see

    https://learn.microsoft.com/en-us/azure/azure-sql/database/logins-create-manage?view=azuresql#authentication-and-authorization