How to have jobs connect to a Microsoft SQL DB with Windows Authentication accounts

Question

How to have jobs connect to a Microsoft SQL DB with Windows Authentication accounts?

Answer

Configure by following these steps:

  1. Download the JTDS driver, extract the contents, and find the ntlmauth.dll.
  2. Move the ntlmauth.dll file to one (or both) of these locations: C:\Program Files\Java\JDK_version\bin\ntlmauth.dll or the Windows folder (C:\Windows\System32\ntlmauth.dll).
  3. Format the connection string in your new database connection (General JDBC) as follows:

    jdbc:jtds:sqlserver://<HOSTNAME>:<PORT>/<REPO_NAME>;user=XXX;password=YYY;useNTLMv2=tru‌e;domain=yourdomain

     

    Note: Ensure that the login, password, server, port, and database fields are blank. If you are doing Windows Authentication, you need to specify them in the connection string, not in the fields.

Version history
Revision #:
3 of 3
Last update:
‎08-01-2017 05:00 PM
Updated by:
 
Contributors
Tags (1)