After upgrading CCC to 2.9.4 MS-SQL datasources setup to use Windows authentication fails to connect to the database.
The ca_ccc_sterr.xxxxx-xx-xx.log shows the following error :
No suitable driver found for jdbc:jtds:sqlserver ..................
If the datasource is configured to use windows integrated authentication to connect to the database , according the following guidelines:
One of the steps is to add the path to the jdbc drivers to the systems path enviroment variable .
Set the Path to the Windows Environment Variable
Add the paths you used in the previous step to the Windows system environment variables (if they are not already present).
Follow these steps:
With the upgrade of CCC the path to the jdbc drivers is changed and needs to be updated to reflect the new location which includes the version of the product .
Path=C:\Program Files\CA\Capacity Command Center 2.9.4 \jre\bin;C:\Program Files\CA\Capacity Command Center 2.9.4\ApacheTomcat\lib;
Restart the Tomcat service, as follows: