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
Comments
adrienlacombe

Hi,

Wondering why this article doesn't mention the use of a MSSQLServer component or how to do that with the metadata wizard instead of using a Generic JDBC connector.

Would it work with the Talend SQL Server components as well?

adrienlacombe

which version of SQL Server is that solution compatible with as well? Thank you.