question

DataArtist avatar image
0 Votes"
DataArtist asked DataArtist edited

How to connect to a SQL server database to do reverse engineering using windows authentication using VISIO ?

Problem :
In a Windows 10 PC , I log in a company domain say Mars and then I launch the Visio desktop app client to do reverse engineering of a SQL server database . My login name to the Domain mars is Mars\testuser and to connect to SQL server is Mars\testuserAdmin account.

I cant reverse engineer because VISIO app doesnt let me connect to SQL server using my Mars\testuserAdmin account.

Note: I can connect to sql server in the same pc by launching the SSMS as other user (Mars\testuserAdmin account)

I want to know how should i connect ?

When I tried opening VISIO as the other user to enter Mars\testuserAdmin admin credentials, i get the below message
84204-image.png

Visio version

84205-image.png


office-visio-itpro
image.png (120.7 KiB)
image.png (10.9 KiB)
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.

1 Answer

emilyhua-msft avatar image
0 Votes"
emilyhua-msft answered DataArtist edited

@DataArtist

Has the SQL Server database been successfully added as the data source?
Please refer to "Use the Data Connection Wizard to import data into Visio", check whether you could import data from SQL Server into Visio via using Windows Authentication.

Is the SQL Server database local or remote?
Please check whether this article "Task Scheduler Error “A specified logon session does not exist”" (Disabled "Do not allow storage of passwords and credentials for network authentication" policy) is helpful.


If an 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.

· 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.

Has the SQL Server database been successfully added as the data source?
Please refer to "Use the Data Connection Wizard to import data into Visio", check whether you could import data from SQL Server into Visio via using Windows Authentication.


Sorry ,which section in the above article I should be working on ?

Is the SQL Server database local or remote?
Is remote and we have a network policy which overrides this .

0 Votes 0 ·