MSSQL Windows Authentication

CosmoRied 4 years ago

What's the MSSQL connection parameters if you need to use Windows authentication?

Anton Tananaev 4 years ago
CosmoRied 4 years ago

Eg. Is it going to accept: Integrated Security=true; in the connection string?

Anton Tananaev 4 years ago

It will accept a valid connection string.

CosmoRied 4 years ago
2021-08-10 12:30:40 ERROR: Main method error - no mssql-jdbc_auth-9.2.1.x64 in java.library.path: 
Anton Tananaev 4 years ago

OK, looks like you would also need to add the library.

CosmoRied 4 years ago

It worked. You need to download the library from github : https://github.com/microsoft/mssql-jdbc & get the exact version.

I found the required .dll in the older releases under 'tags'. Copy and paste the .dll into the jdk bin.