Visio Professional 2019 - Unable to Properly Reverse Engineer from SQL Server 2017
Question
-
I am trying to reverse engineer a database I have on SQL Server 2017. I have tried to use SQL Server Native Client 11.0 and SQL Server but I receive the error: "The currently selected Visio driver is not compatible with the data source." I can connect with the ODBC Driver 17 for SQL Server using Integrated Windows authentication, but it gives the warning:
---------------------------
Microsoft Visio
---------------------------
Warning!
You are using a Visio 'ODBC Generic Driver' driver to connect with a 'Microsoft SQL Server' DBMS datasource.
By using an incompatible driver, it is possible that the catalog information retrieved will be incomplete.
---------------------------
OK
---------------------------
As a result I cannot diagram Triggers, Check clauses, Views, or Stored procedures.
Not only that but when I go to select my drivers, they are all listed in Spanish. I do not have Spanish installed and have selected nothing related to Spanish.
Here are version dumps:
----
OS:
Windows Server 2019 Standard
Version: 1809
OS build: 17763.1012
----
Microsoft SQL Server 2017 (RTM-CU18) (KB4527377) - 14.0.3257.3 (X64)
Nov 16 2019 01:14:50
Copyright (C) 2017 Microsoft Corporation
Enterprise Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: ) (Hypervisor)
----
Visio:
Version 1808 (Build 10730.20102 Click-to-Run)
