MS SqlServer (Native)

Option Info

Type

Relational

Driver

Driver Link

Version Included

None

Hop Dependencies

None

Documentation

Documentation Link

JDBC Url

jdbc:sqlserver://[serverName[\instanceName][:portNumber]][;property=value[;property=value]]

Driver folder

Hop Installation/plugins/databases/mssqlnative/lib

Integrated Authentication / Windows Based Authentication

The native Microsoft SQL JDBC driver ships with extra files that enables authentication using your current MS Windows credentials. When you download the JDBC drivers from Microsoft’s site and unzip them, there will be a directory structure like the following:

sqljdbc_10.2.1.0_enu\sqljdbc_10.2_enu\auth\x64 ← 64bit authentication support files.

sqljdbc_10.2.1.0_enu\sqljdbc_10.2_enu\auth\x86 ← 32bit authentication support files.

You would copy the file:

sqljdbc_10.2.1.0_enu\sqljdbc_10.2_enu\auth\x64\mssql-jdbc_auth-10.2.1.x64.dll

to

hop\lib\mssql-jdbc_auth-10.2.1.x64.dll

The JDBC driver itself sqljdbc_10.2_enu\mssql-jdbc-10.2.1.jre11.jar should be copied into \hop\plugins\databases\mssqlnative\lib

There is no need to rename the DLL to sqljdbc_auth.dll or place it in other locations.