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

question

LesiaMilimonka-3026 asked Apr 21, '22 MarileeTurscak-MSFT edited May 9, '22

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

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-active-directory azure-sql-database

5 |1600 characters needed characters left characters exceeded

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

Answer 1 · 2022-05-09T22:25:52.007Z

MarileeTurscak-MSFT answered May 9, '22 MarileeTurscak-MSFT edited May 9, '22

Hi @LesiaMilimonka-3026,

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.

5 |1600 characters needed characters left characters exceeded

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

question