Since version 20.* it is not possible to reference a package in an (local or remote) SSIS catalog when creating a job step in Microsoft SQL Server Management Studio without proper certificates. In this case the server is local but there does not seem to be a way to connect to “localhost” and avoid this problem (I tried ., , localhost, 127.0.0.1 …). In Microsoft SQL Server Management Studio 19.* this works without error and jobs can be created (and later on seen and run from Microsoft SQL Server Management Studio 20.*).

As soon as I enter IP / hostname and click […] this message appears:

Complete error message:

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)

For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver--2146893019-database-engine-error

------------------------------
ADDITIONAL INFORMATION:

The certificate chain was issued by an authority that is not trusted

------------------------------
BUTTONS:

OK
------------------------------

Connecting to said server without proper certifcates via Microsoft SQL Server Management Studio is no problem since there is an option “Trust server certificate” (which of course is missing in this specific dialog box).

I am looking for a way to work around this issue because I wouldn’t want to use Microsoft SQL Server Management Studio 19.* for the rest of eternity. I tried to follow a Microsoft Guide to share certificates from Server -> client (where Microsoft SQL Server Management Studio is installed hoping it would check against this certificate) but could not find any certificate server side.

Thanks 🙂