NTLM Configuration for SQL Server

Applies to: Denodo 8.0 , Denodo 7.0 , Denodo 6.0
Last modified on: 13 May 2020
Tags: Security NTLM JDBC data sources SQL Server

Download document

You can translate the document:

Goal

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

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

Questions

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

Featured content

DENODO TRAINING

Ready for more? Great! We offer a comprehensive set of training courses, taught by our technical instructors in small, private groups for getting a full, in-depth guided training in the usage of the Denodo Platform. Check out our training courses.

Training