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

Question

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.

Answer 1

Hi @Lesia Milimonka ,

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.