I deployed my ssis project succesfully into SQL Server (vrsion 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
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)
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.
It is a bug in the SSMS 20 and 20.1.
The issue is officially documented in the SSMS release notes, "Known issues 20.1" section: https://learn.microsoft.com/en-us/sql/ssms/release-notes-ssms?view=sql-server-ver16#known-issues-201
When creating or modifying an SSIS job step in a SQL Agent job, you receive the error "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.) (Framework Microsoft SqlClient Data Provider)" regardless of whether Optional or Mandatory is selected for the Encryption property.
For now, until the issue is resolved by Microsoft, use SSMS 19.3 or earlier to create or modify SSIS job steps.
