Hi Everyone I am unable to establish a JDBC connection to a MS SQL 2012 server below I have listed all the details relating to this problem.
Thank you in advance Regards Stefan ************************************************************ ************************************************************ NIFI: 1.14.0 uname -a: 5.13.14-200.fc34.x86_64 #1 SMP Fri Sep 3 15:33:01 UTC 2021 x86_64 x86_64 x86_64 GNU/Linux Java: OpenJDK Runtime Environment 18.9 (build 11.0.12+7) OpenJDK 64-Bit Server VM 18.9 (build 11.0.12+7, mixed mode, sharing) JDBC URL: jdbc:sqlserver://;serverName=db.xxxxx.xxx.xxx;databaseName=master;trust ServerCertificate=true;sslProtocol=TLS MS SQL Server: Ms SQL server 2010 OS: Windows Server 2012 R2 ERROR: 10:11:42 SASTERRORf312e911-017b-1000-7f31-6ce540797406 GenerateTableFetch[id=f312e911-017b-1000-7f31-6ce540797406] Failed to process session due to java.sql.SQLException: Cannot create PoolableConnectionFactory (The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "Unexpected rethrowing".): java.io.IOException: SQL Server did not return a response. The connection has been closed. ClientConnectionId:20991be1-62eb-424a-9df0-5868eb642a12 ↳ causes: javax.net.ssl.SSLException: Unexpected rethrowing ↳ causes: com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "Unexpected rethrowing". ↳ causes: java.sql.SQLException: Cannot create PoolableConnectionFactory (The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "Unexpected rethrowing".) ↳ causes: org.apache.nifi.processor.exception.ProcessException: java.sql.SQLException: Cannot create PoolableConnectionFactory (The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "Unexpected rethrowing".)
