I am trying to use Visio to reverse engineer an Azure SQL Data using Azure Active Directory - Integrated authentication. But then I am asked for a username and password.base using

Anonymous
2022-04-21T12:35:56.653+00:00

I am trying to use Visio to reverse engineer an Azure SQL Database using Azure Active Directory - Integrated authentication. But then I am asked for a username and password and then I get this error in Visio:

Cannot use authentication option 'ActiveDirectoryIntegrated' with User or Password options.

Azure SQL Database
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
19,436 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Marilee Turscak-MSFT 33,801 Reputation points Microsoft Employee
    2022-05-09T22:25:52.007+00:00

    Hi @Anonymous ,

    Thanks for your post and apologies for the delayed response!

    You cannot connect with Azure Server using Active Directory Integrated authentication from Visio. You need to use SQL authentication and by providing the username and password for the connection.

    You need to specify Authentication=ActiveDirectoryPassword in the connection string as noted here and here:

    server=Server;database=Database;UID=UserName;PWD=Password;Authentication=ActiveDirectoryPassword;

    -
    If the information provided was helpful to you, please remember to "mark as answer" so that others in the community with similar questions can more easily find a solution.

    0 comments