Contents x
    Windows Authentication (SQL Server JDBC)
    • 13 Sep 2023
    • 1 Minute to read
    • Print
    • Dark
      Light
    Contents

    Windows Authentication (SQL Server JDBC)

    • Updated on 13 Sep 2023
    • 1 Minute to read
    • Print
    • Dark
      Light
    Article summary

    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
    Was this article helpful?
    What's Next