This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(48, 41%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETA%3C/text%3E%3C/svg%3E)
Hello,
I'm getting error "com.microsoft.sqlserver.jdbc.SQLServerException: "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" in talend microsoft sql server component of talend job. We have tried updating the mssql jdbc jar but didn't worked.
Can you please help us.
Regards,
Abhishek Tehra
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
If you are not using a purchased certified for your Sqlserver, then you are using a self signed untrusted ssl cert. you need to set trustServerCertificate = true in the connect string.
the o/s must support overriding the certificate validation. If not, you need to install and trust the cert on the local machine or not use encryption.
Hello Bruce,
At first the connection is getting successful from the studio after some operations it is getting failed with an error.
Also when we connect the database from SQL Server Management Studio, it is connected successful.
We have tried using trustServerCertificate = true but still it fails
Regards,
Abhishek Tehra
We have tried using trustServerCertificate = true but still it fails
Well, the error message explicitly says that trustServerCertificate is set to false, so you may have to set it in the wrong place, or not in all places where you need to set it. That is, your application may be setting up connection strings in more than one place.