Installing and Configuring the Microsoft SQL Server JDBC Driver

Microsoft does not allow the redistribution of the JDBC driver for the Structured Query Language (SQL) server by other vendors, such as Oracle. So, you need to download it from the Microsoft website, and install it into the PS_HOME\class directory.

Follow the instructions on the Microsoft download site to obtain and install the JDBC driver. The latest driver at the time of publication is Microsoft JDBC Driver 12.8 for SQL Server. Update the "Add to CLASSPATH" parameter in the General Settings for PSTOOLS section with the path to the JDBC driver. For example:

Add to CLASSPATH=<PS_HOME>\class\mssql-jdbc-12.8.0.jre11.jar