Windows Authentication (SQL Server JDBC)

  • Updated on Sep 13, 2023
  • Published on Jan 14, 2022
  • 1 minute(s) read
Prev Next

Enabling Windows Authentication for SQLServer JDBC driver

The SQLServer JDBC driver allows you to log in to SQLServer using a Windows account (that has been granted appropriate access in SQLServer). The JDBC driver needs a native Windows DLL to perform this function.

Requirements:

  1. Latest version of DataWORQ installed on a Windows server

  2. mssql-jdbc_auth-11.2.3.x64.dll copied to your Java installation's bin directory on the Tomcat server

mssql-jdbc_auth-11.2.3.x64.dll is included in the installation files provided with the application under Tomcat/put_these_in_java_bin_path


In DataWORQ:
Windows Auth JDBC.png

  • User: can leave blank
  • Password: can leave blank
  • URL: must have integratedSecurity=true; in URL