Usually, the drivers are installed in an external location (external from SDC runtime directory). You should be able to find the location in the SDC UI --> Administration icon --> SDC Directories --> SDC Libraries Extra Directory.
Please follow these steps:
1. Download the new version of the MS SQL Server JDBC driver.
2. Back up the older version of the driver from <SDC Libraries Extra Directory>/streamsets-datacollector-jdbc-lib/lib. You can find the SDC Libraries Extra Directory in the SDC UI --> Administration icon --> SDC Directories --> SDC Libraries Extra Directory (please see attached print screen).
mkdir /opt/backup
cd <SDC Libraries Extra Directory>/streamsets-datacollector-jdbc-lib/lib
cp <jdbc_driver_older_mssql_server_version>.jar /opt/backup
To replace the driver manually:
3. Remove the older version of MS SQL JDBC driver in <SDC Libraries Extra Directory>/streamsets-datacollector-jdbc-lib/lib
rm <jdbc_driver_older_mssql_server_version>.jar
4. Add the new version of MS SQL Server JDBC driver downloaded in the first step to <SDC Libraries Extra Directory>/streamsets-datacollector-jdbc-lib/lib:
cp <location_of_downloaded_file>/<jdbc_driver_later_mssql_server_version>.jar <SDC Libraries Extra Directory>/streamsets-datacollector-jdbc-lib/lib
5. Restart the SDC. If you are using Cloudera Manager, restart the SDC from Cloudera Manager UI --> StreamSets service --> Actions --> Restart (please see attached print screen).
To replace the driver by using Package Manager:
1. Go to Package Manager in the SDC UI (please see attached print screen).
2. Click on External Libraries.
3. Check the older version of the MS SQL Server JDBC driver.
4. Click on the delete button. (please see attached print screen)
5. You do not have to restart the SDC for now.
6. Upload the new version of MS SQL Server JDBC driver - click on the Install External Libraries button, pick JDBC stage library and browse the new version of MS SQL Server JDBC driver, which you downloaded in the first step and upload it.
7. Restart the SDC service. If you are using Cloudera Manager, restart the SDC from Cloudera Manager UI --> StreamSets service --> Actions --> Restart (please see attached print screen).
For more information, you can also go to our documentation here.