Sql Server - Import Export Wizard - cannot find an authentication provider for activedirectoryinteractive

Rsam111 1 Reputation point
2020-09-17T11:58:25.443+00:00

Hello All

When I try to export data from Azure sql server by using Sql Server Import Export Wizard, I get the error as follows,

"cannot find an authentication provider for activedirectoryinteractive"

I use ".Net Framework Data Provider for Sql Server" and Authentication option is Active Directory Interactive (MFA)

SSMS Version is 18.2

Any help would be greatly appreciated

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.
8,578 questions
{count} votes

1 answer

Sort by: Most helpful
  1. AmeliaGu-MSFT 13,881 Reputation points
    2020-09-21T00:51:09.497+00:00

    Hi @Rsam111 ,

    It seems AAD Interactive is not supported in the Import Export wizard.
    Please refer to this feedback.
    You can vote for this feedback or submit a new one to this link.
    Your feedback enables Microsoft to offer the best software and deliver superior services, meanwhile you can learn more about and contribute to the exciting projects on Microsoft feedback.

    Best Regards,
    Amelia


    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.