question

mikejakubik-9988 avatar image
0 Votes"
mikejakubik-9988 asked mikejakubik-9988 commented

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

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AlbertoMorillo avatar image
0 Votes"
AlbertoMorillo answered mikejakubik-9988 commented

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.

· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

It is the latest DMA and i do not use 2FA, just an email login and password. It's asking me for the Azure login, not the login to the actual DB.

0 Votes 0 ·

{Please SQL Suthentication instead of Windows Authentication

0 Votes 0 ·

There is no such option provided, it just asks for the login to Azure.

0 Votes 0 ·

This tool is confusing, if i actually try to do the migration to Azure Managed SQL it says to use Azure Database Migration Service (DMS) instead.

0 Votes 0 ·
KalyanChanumolu-MSFT avatar image
0 Votes"
KalyanChanumolu-MSFT answered mikejakubik-9988 commented

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

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I just setup SQL in a VM - the managed version was too restrictive and a PITA to setup.

0 Votes 0 ·