RESOLVED - MSSQL Server 2019 Connection Fails - This driver is not configured for integrated authentication

Ignition
#1

Ignition Version: 8.1.14
Followed the instructions according linke below Scenario 2
https://docs.inductiveautomation.com/display/DOC81/Connecting+to+Microsoft+SQL+Server
But still get faulted connection to the MSSQL Server

Any tips?

Thanks!

#2

Did you happen to see this thread?

#3

I had an issues with Integrated security.

  1. I played with some new JDBC versions like 10+ - it not worked. 9.4.0 is working correctly.
  2. The problem is that JDBC is referencing itself somehow, so it looking for file with the name mssql-jdbc_auth-9.4.0.x64. So all what i did to solve the issue which i had - copied JBDC file - named it as ignition document want. And then placed the same file but didn’t renamed it. So i have 2 same files but with different names.
    image
#4

@JordanCClark
@y.parashchuk

Thanks, I now used also the 2 files one renamed and the other not renamed but had also to copy the unrenamed file into the lib/core/gateway folder but then it worked!

Thanks a lot for the tips! :+1: