You can translate the document:

Goal

This document explains how to connect to SQL Server using the jTDS driver and NTLM authentication.

NOTE: The jTDS driver is no longer maintained and its use should be avoided.

Content

NTLM (NT LAN Manager) is a suite of Microsoft security protocols that provides authentication, integrity, and confidentiality to users.

The jTDS driver from SQL Server allows the user to connect to a database using NTLM authentication instead of using the normal SQL Server authentication.

The URL format for jTDS is:

  • jdbc:jtds:<server_type>://<server>[:<port>][/<database>][;<property>=<value>[;...]]

where <server_type> is one of either 'sqlserver' or 'sybase', <port> is the port the database server is listening to and <database> is the database name (if not specified, the user's default database is used).

There are different properties that can be used but the important ones for NTLM authentication are the following:

  • user:
  • Username to use for log in.
  • password:
  • Password to use for log in.
  • domain:
  • Specifies the Windows domain for authentication:
  • If specified and the username and password are provided, jTDS uses Windows (NTLM) authentication instead of the usual SQL Server authentication (i.e. the user and password provided are the domain user and password). This allows non-Windows clients to log into servers which are only configured to accept Windows authentication.
  • If the domain parameter is present but no username and password are provided, jTDS uses its native Single-Sign-On library and logs in with the logged Windows user's credentials.
  • useNTLMv2 (default - false):
  • Set to true to send LMv2/NTLMv2 responses when using Windows authentication.

References

JTDS URL format

Disclaimer
The information provided in the Denodo Knowledge Base is intended to assist our users in advanced uses of Denodo. Please note that the results from the application of processes and configurations detailed in these documents may vary depending on your specific environment. Use them at your own discretion.
For an official guide of supported features, please refer to the User Manuals. For questions on critical systems or complex environments we recommend you to contact your Denodo Customer Success Manager.

Questions

Ask a question

You must sign in to ask a question. If you do not have an account, you can register here