Obtain and Install the Driver for SQL Server

Obtain and install the JDBC driver for SQL Server

1. Visit the following URL for the Microsoft JDBC Driver for SQL Server Web page and download the JDBC driver for your version of SQL Server:
http://msdn.microsoft.com/en-us/data/aa937724.aspx
2. Follow the instructions provided to extract the files for your version of SQL Server.
3. Locate the JAR file for your version.

Version

JAR File

2008, 2012, 2014

sqljdbc4.jar

or

sqljdbc_<version>_<language>.tar.gz

2019

mssql-jdbc-7.4.1.jre11.jar

mssql-jdbc-7.4.1.jre11.jar

4. Put the JAR file in the directory appropriate to the version:
<TDV_install_dir>\conf\adapters\system\microsoft_sql_server_<ver> 

For UNIX, navigate to the directory where you want the driver unpacked, and type:

gzip -d sqljdbc_<version>_<language>.tar.gz.
5. Restart the TDV Server.
6. If integrated security is required, it is recommended the you keep the SQL server JDBC drivers in a common location. For example, <TDV_install_dir>\apps\dlm\cis_ds_mssql\lib.