Data Migration Assisant fails with "Failed to fetch subscription list from Azure. AADSTS50074: Strong Authentication is required."

mike jakubik 16 Reputation points
2021-08-30T14:01:00.553+00:00

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?

Azure SQL Database
{count} votes

2 answers

Sort by: Most helpful
  1. Alberto Morillo 33,176 Reputation points MVP
    2021-08-30T16:02:14.137+00:00

    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.


  2. KalyanChanumolu-MSFT 8,316 Reputation points
    2021-09-08T07:17:47.157+00:00

    @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.