Connection to MS SQL server

How To
1

I’m evaluating this software. I love everything except connecting to SQL Server isn’t as easy as I thought.

I selected

“.NET” as Language
MS SQL Server
Version: 2008 or higher
Driver: MS SQL Server
Adapter file: jTDS 1.3.1 << this is the only selection I have tho

I’m trying to use Windows Authentication, but I got below error message

java.sql.SQLException: I/O Error: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property.
at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:654)
at net.sourceforge.jtds.jdbc.JtdsConnection.(JtdsConnection.java:371)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
at org.orm.ertodb.DriverWrapper.connect(DriverWrapper.java:27)
at v.aam.c.a(:66)
at v.aam.c.b(:78)
at v.aam.av.run(:25)

2

Hi,

Please try the following steps to solve Windows Authentication issue:

  1. download jtds driver:
    https://sourceforge.net/projects/jtds/files/latest/download
  2. extract ntlmauth.dll from the zip to visual paradigm bin folder, e.g. Visual Paradigm 16.1\Application\bin
  3. Set connection string as:
    Server=%HOST%,%PORT%;Database=%DATABASE%;Trusted_Connection=Yes;Domain=workgroup
    e.g.
    Server=localhost,1433;Database=test;Trusted_Connection=Yes;Domain=workgroup