MSSQL Windows Authentication

CosmoRied3 years ago

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

Anton Tananaev3 years ago

You can try integratedSecurity=true parameter.

https://docs.microsoft.com/en-us/sql/connect/jdbc/building-the-connection-url?view=sql-server-ver15#Connectingintegrated

CosmoRied3 years ago

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

Anton Tananaev3 years ago

It will accept a valid connection string.

CosmoRied3 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 Tananaev3 years ago

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

CosmoRied3 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.