1/23/2024 0 Comments Decode sqlserver![]() ClientConnectionId:c53d983f-3d41-4d06-997c-efb5b135ff7e)Īt 2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2385)Īt 2.BasicDataSource.createDataSource(BasicDataSource.java:2110)Īt 2.BasicDataSource.getConnection(BasicDataSource.java:1563)Īt .(DatasourceImpl.java:250)Īt .(DatasourceImpl.java:203)Īt .datasource.DatasourceManagerImpl$FaultedDatasourceRetryer.lambda$newRetryRunnable$0(DatasourceManagerImpl.java:1061)Īt .$n(BasicExecutionEngine.java:581)Īt java.base/$RunnableAdapter.call(Unknown Source)Īt java.base/.runAndReset(Unknown Source)Īt java.base/$n(Unknown Source)Īt java.base/.runWorker(Unknown Source)Īt java.base/$n(Unknown Source)Īt java.base/(Unknown Source)Ĭaused by: .SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. : Cannot create PoolableConnectionFactory (The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. My connection faults with the following error. The database connection always faults with the same error and appears to be related to using an encrypted connection. I have Force Encryption set to “No” for SQL Express Protocols. I am using the TCP/IP protocol for SQLEXPRESS. I’ve experimented with connection parameters to disable encrypted connections. ![]() I am also using the sqljdbc_auth.dll so that my connection leaves the username and password blank and will use the account configured to login to the Ignition system service. ![]() I updated the SQL JDBC driver to version 9.2. It looks like I need version 7.4 or greater to connect to SQL 2019. I hope somebody out there has seen this error and can offer a suggestion. It looks like the SQL JDBC driver version installed with Ignition is version 7.2.1. On the same node I have a new installation of Ignition v8.1.3. I have a fresh installation of SQL Server 2019 (SQLEXPRESS).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |