# SQL Database connection issue after restore **URL:** \ **Category:** Ignition\ **Created:** [July 19, 2024, 7:22pm UTC](https://forum.inductiveautomation.com/t/sql-database-connection-issue-after-restore/93487 "2024-07-19T19:22:10Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Luke\_Waller](https://avatars.discourse-cdn.com/v4/letter/l/46a35a/32.png) [@Luke\_Waller](https://forum.inductiveautomation.com/u/Luke_Waller)\ **Post date:** [July 19, 2024, 7:22pm UTC](https://forum.inductiveautomation.com/t/sql-database-connection-issue-after-restore/93487/1 "2024-07-19T19:22:10Z")
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' " ---
**Author:** ![Samuel\_Sueur](https://avatars.discourse-cdn.com/v4/letter/s/e36b37/32.png) [@Samuel\_Sueur](https://forum.inductiveautomation.com/u/Samuel_Sueur)\ **Post date:** [July 19, 2024, 8:18pm UTC](https://forum.inductiveautomation.com/t/sql-database-connection-issue-after-restore/93487/2 "2024-07-19T20:18:35Z")
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: > **[JDBC Drivers and Translators | Ignition User Manual](https://www.docs.inductiveautomation.com/docs/8.1/platform/database-connections/connecting-to-databases/jdbc-drivers-and-translators)** > > There are cases where drivers or translators may need modification. ---
**Author:** ![Luke\_Waller](https://avatars.discourse-cdn.com/v4/letter/l/46a35a/32.png) [@Luke\_Waller](https://forum.inductiveautomation.com/u/Luke_Waller)\ **Post date:** [July 19, 2024, 8:20pm UTC](https://forum.inductiveautomation.com/t/sql-database-connection-issue-after-restore/93487/3 "2024-07-19T20:20:18Z")
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) ---
**Author:** ![diamond](https://avatars.discourse-cdn.com/v4/letter/d/e79b87/32.png) [@diamond](https://forum.inductiveautomation.com/u/diamond)\ **Post date:** [July 19, 2024, 8:22pm UTC](https://forum.inductiveautomation.com/t/sql-database-connection-issue-after-restore/93487/4 "2024-07-19T20:22:02Z")
Try disabling encryption. ---
**Author:** ![Luke\_Waller](https://avatars.discourse-cdn.com/v4/letter/l/46a35a/32.png) [@Luke\_Waller](https://forum.inductiveautomation.com/u/Luke_Waller)\ **Post date:** [July 19, 2024, 8:22pm UTC](https://forum.inductiveautomation.com/t/sql-database-connection-issue-after-restore/93487/5 "2024-07-19T20:22:40Z")
I have been looking for that option, not sure what I am missing ---
**Author:** ![Samuel\_Sueur](https://avatars.discourse-cdn.com/v4/letter/s/e36b37/32.png) [@Samuel\_Sueur](https://forum.inductiveautomation.com/u/Samuel_Sueur)\ **Post date:** [July 19, 2024, 8:24pm UTC](https://forum.inductiveautomation.com/t/sql-database-connection-issue-after-restore/93487/6 "2024-07-19T20:24:03Z")
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. ---
**Author:** ![Luke\_Waller](https://avatars.discourse-cdn.com/v4/letter/l/46a35a/32.png) [@Luke\_Waller](https://forum.inductiveautomation.com/u/Luke_Waller)\ **Post date:** [July 19, 2024, 8:25pm UTC](https://forum.inductiveautomation.com/t/sql-database-connection-issue-after-restore/93487/7 "2024-07-19T20:25:28Z")
Just says: databaseName=Robot ---
**Author:** ![Samuel\_Sueur](https://avatars.discourse-cdn.com/v4/letter/s/e36b37/32.png) [@Samuel\_Sueur](https://forum.inductiveautomation.com/u/Samuel_Sueur)\ **Post date:** [July 19, 2024, 8:29pm UTC](https://forum.inductiveautomation.com/t/sql-database-connection-issue-after-restore/93487/8 "2024-07-19T20:29:31Z")
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. ---
**Author:** ![Luke\_Waller](https://avatars.discourse-cdn.com/v4/letter/l/46a35a/32.png) [@Luke\_Waller](https://forum.inductiveautomation.com/u/Luke_Waller)\ **Post date:** [July 19, 2024, 8:32pm UTC](https://forum.inductiveautomation.com/t/sql-database-connection-issue-after-restore/93487/9 "2024-07-19T20:32:08Z")
Thanks Samuel, I will give that a try. Much appreciated ---
**Author:** ![Luke\_Waller](https://avatars.discourse-cdn.com/v4/letter/l/46a35a/32.png) [@Luke\_Waller](https://forum.inductiveautomation.com/u/Luke_Waller)\ **Post date:** [July 19, 2024, 8:59pm UTC](https://forum.inductiveautomation.com/t/sql-database-connection-issue-after-restore/93487/10 "2024-07-19T20:59:01Z")
As far as I can tell, that worked!!