SSIS Connection Error with SSL Certificates


 

  
 Applies To 
  
 Product(s):eB SSIS
 Version(s):16.7.X
 Environment: N/A
 Area: SSIS Conection
 Subarea: Setup
 Original Author:Roberto Garcia, Bentley Product Support

Problem Description:

When trying to connect SSIS components it throws an exception error as shown below:

Cause:

Bentley delivers an eB Connection Manager component to use with packages in Microsoft SSIS. Credential information can be entered on the eB Connection Manager form in SSDT and saved with the SSIS package or the information can be stored in an eB ConnectInfo string attribute which our execute package engine will pass to the package when it executes. When the information is saved with the package, it is encrypted and when it is stored as an attribute we should encrypt it as well. The server name is included in  connection information and server name used should match the server name in SSL Certificate used.

Solution:

Since the error message points to the server name being wrong (missing the domain), you may need to update the SSIS package or the connect string (whichever way is used) to specify the correct server name , including the domain name that does work with your certificate.

Workaround:

N/A