Skip to main content

Microsoft SQL Server (MSSQL) Connection Guide for Ignition

Comments

2 comments

  • Wesley Phan
    • Attempted to replace mssql-jdbc_auth in Ignition v8.1.16, copied over the latest version mssql-jdbc_auth-10.2.0.x64.
    • Got an error.
    •  
    • Caused by: java.lang.UnsatisfiedLinkError: no mssql-jdbc_auth-9.4.0.x64 in java.library.path: [lib, lib\core\gateway] 
    • I think this functionality might not be working.
    • Note: Older versions of the JDBC driver (such as version 7.2.1) need to be renamed to sqljdbc_auth.dll before Ignition can utilize the file. However, in more modern versions of the driver, this is no longer the case.
    •  
    0
  • James Sørlie

    re: scenario 2 (WAM)

    With microsoft's latest release of the JDBC (10.2.1) we found it necessary use a few more "extra connection prop's" as suggested here.

    databaseName=IgnitionDB; integratedSecurity=true;encrypt=true;trustServerCertificate=true;

    Unpack from the JDBC download the following:

    • mssql-jdbc_auth-10.2.1.x64.dll  in  ..\Ignition\lib\
    • mssql-jdbc-10.2.1.jre11.jar  in ..\Ignition\user-lib\jdbc\

    (modulo whatever your JRE version is)

    0

Please sign in to leave a comment.

This article has 2 comments.