Page 1 of 1

SQL Server: JDBC Connection Configuration

PostPosted: 07 Dec 2018, 16:04
by rboehnke

Microsoft SQL Server® databases allow connecting to a server using two distinct modes: SQL Server Authentication and Windows® Authentication:


SQL Server Authentication Mode: Logging in with a SQL user with login/with password:

1. Driver download: https://docs.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-2017

2. Create new database driver:

Type: Microsoft SQL Server
Driver file: mssql-jdbc-<version>.jar

3. Create a new data warehouse using the driver configured above with this configuration:

Database name: <Database name>
Host: <Host address>
Port: <Port in which SQL Server is running>
Integrated security: false

Windows® Authentication Mode: Logging in with a Windows user

First case: same domain for the current user and the server:

1. Driver download: https://docs.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-2017

2. Create a new database driver:

Type: Microsoft SQL Server
Driver file: mssql-jdbc-<version>.jar

3. Create a new data warehouse using the driver configured above with this configuration:

Database name: <Database name>
Host: <Host address>
Port: <Port in which SQL Server is running>
Integrated security: True

4. Identify if RapidRep is installed as 32 or 64 bit, then copy one of these files to the RapidRep application folder (where the Designer.exe file of the current installation is located within):

<driver folder>\enu\auth\x86\ sqljdbc_auth.dll
<driver folder>\enu\auth\x64\ sqljdbc_auth.dll

After configuring the data warehouse, the connection can be tested without having to type any user and password within the fields required for the “Connection test” dialog, as long as the current user is the one configured previously.

Second case: different domain for the current user and the server:

The Windows® Authentication mode can be used to connect to domains other than the one in which the current user is logged on by using the jTDS SQL Server Driver using NTLM. To do so, follow these steps:

1. Driver download: http://jtds.sourceforge.net
2. Create a new database driver:

Type: jTDS Microsoft SQL
Driver file: jtds-<version>.jar

3. Create a new data warehouse using the driver configured above with this configuration:

Database name: <Database name>; useNTLMv2=true;domain=<Domain>
Host: <Host address>
Port: <Port in which SQL Server is running>

4. Identify if RapidRep is installed as 32 or 64 bit, then copy one of these files to the RapidRep application folder (where the Designer.exe file of the current installation is located within):

<driver folder>\x86\SSO\ntlmauth.dll
<driver folder>\x64\SSO\ntlmauth.dll

After configuring the data warehouse and copying the file above, the connection can be tested by typing the user (without the domain) and the password of the domain user within the fields required for the “Connection test” dialog, as long as the domain user is the one configured previously.