Probable you are using Multi-factor Authentication (MFA) on that Azure account. As a workaround try to disable MFA or try to connect to Azure SQL database using a SQL login.
Update DMA to the latest version.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi,
I am trying to migrate a local SQL 2017 db to an Azure managed SQL instance. When running the Data Migration Assistant tool i cant connect to my Azure account (the login provided is correct), i get this error:
Failed to fetch subscription list from Azure.
AADSTS50074: Strong Authentication is required.
Trace ID: 7d436503-86f0-4bd0-ae7e-342bd0019800
Correlation ID: edcbc45c-b10b-456d-bff4-274447c49f65
Timestamp: 2021-08-30 13:53:04Z
If it needs it, why doesn't it just use it?
Probable you are using Multi-factor Authentication (MFA) on that Azure account. As a workaround try to disable MFA or try to connect to Azure SQL database using a SQL login.
Update DMA to the latest version.
@mike jakubik We are sorry you are having issues with the migration.
Azure Database Migration Service needs to be provisioned in Azure before you can use Data Migration Assistant tool for migration.
The steps to deploy the service are here.
You can then follow the step-by-step tutorial to Migrate SQL Server to an Azure SQL Managed Instance using DMS.
Please let us know if you face any issues during the process.
----------
If an answer is helpful, please "Accept answer" or "Up-Vote" which might help other community members reading this thread.