Unable to migrate to Azure SQL Database

Question

I'm trying to migrate a Sql Server 2008 R2 physical machine to an Azure SQL Database.
It fails with the following error:
Schema Migration for database 'database-name' failed in state 'MonitorSqlSchemaCopy'. See migration status details for more information. Summary of errors: Failed to migrate schema. 'Le nom d’utilisateur ou le mot de passe est incorrect'[

{

"errorCode": 0,

"message": "Failed to migrate schema due to 'Le nom d’utilisateur ou le mot de passe est incorrect'",

"details": []

}

] See link for more troubleshooting steps: https://aka.ms/dms-migrations-troubleshooting#error-code-2060---sqlschemacopyfailed

This error message is not documented in the link above, and the wizard from the portal has no issue letting me select the source and the target database, and objects to migrate. So it has access to everything through SHIR, obviously.

I do not understand, the two users I'm using are administrator. On the source I'm using Windows Authentication, and SQL Authentication on the target.

Please help.

Answer 1

Good news, using Sql Authentication on both source and target solved the problem. The migration is in progress.

Answer 2

Hi Olivier Matrot
It sounds like you're hitting a snag with the migration process from SQL Server 2008 R2 to Azure SQL Database. The error message you're seeing, 'Le nom d’utilisateur ou le mot de passe est incorrect', which translates to 'The username or password is incorrect', usually points to an authentication issue between your source and target databases.

Here are a couple of troubleshooting steps you can try:

1. Verify Credentials: Make sure that the username and password for your Azure SQL Database are correct. Since you're using SQL Authentication for the target database, double-check these details.
2. Windows Authentication: Since you're using Windows Authentication for the source, ensure that you're appropriately configured for this type of access. Note that Azure SQL Database does not support Windows Authentication directly; ensure that you're using SQL logins for both source and target if possible.
3. Schema Migration First: Before you attempt to migrate data, ensure that the schema migration is successfully completed first. The error suggests it may not be able to migrate the schema correctly, so ensure your Azure SQL Database target is prepared and can accept the schema appropriately.
4. Collation Issues: Although not explicitly mentioned in your error, collation can sometimes cause issues during migration. Make sure that the collation settings between your source and target databases align. For Azure SQL Database, the default collation is SQL_Latin1_General_CP1_CI_AS.
5. Database Migration Service Logs: Check the logs for more detailed error messages. The Azure Database Migration Service (DMS) may provide additional context on what went wrong.

If these steps don't resolve the issue, it would be helpful to gather more details. Here are some follow-up questions that can provide clarity:

1. What authentication method are you using for the source SQL Server during the migration (Windows Authentication or SQL Authentication)?
2. Have you successfully migrated any other databases before, or is this the first attempt?
3. Are there any specific permissions that might be restricting access to the databases?
4. Can you confirm the collation settings for both the source SQL Server and the target Azure SQL Database?
5. Are there any other specific settings or configurations in the migration process that you're uncertain about?

Hope this helps clarify things a bit! Let me know if you need further assistance!