SXI Forum

LaurenD

XLayer Dev

Registered: 22-11-2018

Posts: 3

Using Windows Authentication with Spring

When using the 'com.microsoft.sqlserver.jdbc.SQLServerDriver' Microsoft driver with Spring to connect to a MSSQL database using WINDOWS AUTHENTICATION, the following URL should be used:

spring.datasource.url=jdbc:sqlserver://127.0.0.1:1433;databaseName=TestDB;integratedSecurity=true;encrypt=false;authenticationScheme=NTLM;user=xxx;password=xxx