I tried everything to solve this but I couldn’t.
I deployed my ssis project succesfully into SSMS (version 20 and mssql 16) Integration Services catalog. But when I try to create a new job, the moment I add a step and select the type to SSIS package and package source to ssis catalog, the moment i click browse for package after i enter my server name I get this error : TITLE: SSIS Execution Properties
A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 – The certificate chain was issued by an authority that is not trusted.) (Microsoft SQL Server, Error: -2146893019)enter image description here
This is the error log by windows event viewer : The certificate received from the remote server was issued by an untrusted certificate authority. Because of this, none of the data contained in the certificate can be validated. The TLS connection request has failed. The attached data contains the server certificate.
The SSPI client process is Ssms (PID: 4248).enter image description here
I tried a lot of solutions that I found online but none have worked, please any little help u can spare I ll appreciate as this is for my internship project validation. Thank you in advance
groucho is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.