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

asked 2021-04-03T13:33:01.693+00:00
DataArtist 556 Reputation points

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

Visio Management
Visio Management
Visio: A family of Microsoft products used to create diagrams and vector graphics.Management: The act or process of organizing, handling, directing or controlling something.
231 questions
No comments
{count} votes

1 answer

Sort by: Most helpful
  1. answered 2021-04-05T08:33:29.093+00:00
    Emily Hua-MSFT 21,526 Reputation points Microsoft Employee

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