Windows Authentication

  • Published on Jan 9, 2023
  • 1 minute(s) read
Prev Next

Enabling Windows Authentication for SQLServer JDBC driver

The SQLServer JDBC driver allows you to login 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 Euclid Studio installed on a Windows server
  2. sqljdbc_auth.dll copied to C:\Windows\System32 on Tomcat server

Here are the files on SFTP:
sftp-1.png

In Euclid Studio:
sftp-2.png

  • User: domain\user or machine\user
  • Password: Windows domain or machine password
  • URL: must have integratedSecurity=true; in URL