Relative Content

Tag Archive for sqlsslssisssms

SSIS job step fail : Not using SSL certificate but getting error

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