question nifi The driver could not establish a secure connection to sql server by using secure sockets layer in Support Questions

nifi The driver could not establish a secure connection to sql server by using secure sockets layer

vkotsas — Tue, 14 Jun 2022 08:43:50 GMT

Hi do you have any ide what how i solve the above error

Re: nifi The driver could not establish a secure connection to sql server by using secure sockets layer

ckumar — Tue, 14 Jun 2022 09:18:35 GMT

How you are passing SSL details in DBCPConnectionPool used by ConvertJSONToSQL? in configured JDBC URL?

Re: nifi The driver could not establish a secure connection to sql server by using secure sockets layer

vkotsas — Tue, 14 Jun 2022 09:22:08 GMT

yes my jdbc is the below

jdbc:sqlserver://uxxxxx:1433;encrypt=true;trustServerCertificate=true;database=xxx;

Re: nifi The driver could not establish a secure connection to sql server by using secure sockets layer

ckumar — Tue, 14 Jun 2022 12:15:12 GMT

I per MS SQL docs I found this example String connectionUrl =
"jdbc:sqlserver://localhost:1433;" +
"databaseName=AdventureWorks;integratedSecurity=true;" +
"encrypt=true; trustServerCertificate=false;" +
"trustStore=storeName;trustStorePassword=storePassword"; Can you please check ? also the URL which you have used works outside of nifi ?

Re: nifi The driver could not establish a secure connection to sql server by using secure sockets layer

VidyaSargur — Fri, 17 Jun 2022 07:32:41 GMT

@vkotsas, Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.