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.
Thanks Samuel, I will give that a try. Much appreciated
As far as I can tell, that worked!!