SQL Database connection issue after restore

We where effected by the Crowdstrike "mistake". I am trying to get everything back up and running. I was able to recover an old version of the OS and installation. Then I recovered a backup of ignition. After that I got this error "Cannot load JDBC driver class 'com.microsoft.sqlserver.jdbc.SQLServerDriver' "

Hi, the JDBC driver is probably missing or corrupted ?

Try to download a new one for your appropriate database by following this link in the official Documentation:

Thanks Samuel, I did that. It is still not connecting but for a different reason:
Cannot create PoolableConnectionFactory ("encrypt" property is set to "true" and "trustServerCertificate" property is set to "false" but the driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption: Error: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target. ClientConnectionId:912de56e-52d6-4b89-bde6-238369c5fd96)

Try disabling encryption.

I have been looking for that option, not sure what I am missing

In your Database Connection properties, there should be a field "Extra Connection Properties", check if there's anything related to encryption or SSL in this.

Just says: databaseName=Robot

Last suggestions from me, try the following for the database connection properties:

1 - databaseName=Robot;trustServerCertificate=true
Else : 2 - databaseName=Robot;encrypt=false

Please be aware that adding encrypt=false obviously weakens your security.

If neither of these work, I shall let the experts on the forum help you.

2 Likes

Thanks Samuel, I will give that a try. Much appreciated

As far as I can tell, that worked!!