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. |