Connection to MS SQL server

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(
at net.sourceforge.jtds.jdbc.JtdsConnection.(
at net.sourceforge.jtds.jdbc.Driver.connect(
at org.orm.ertodb.DriverWrapper.connect(
at v.aam.c.a(:66)
at v.aam.c.b(:78)


Please try the following steps to solve Windows Authentication issue:

  1. download jtds driver:
  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: