Unable to import the connection file. Please contact your administrator

Error Message

Attempting to add a publisher database connection when adding a data store fails, and the following error is returned:

Error: 
Unable to import the connection file. Please contact your administrator.

The following error is returned in the Portal for ArcGIS logs:

Error: 
URL '<https://machine.domain.com:6443/arcgis/admin/uploads/upload>' is not accessible: Error. PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target.

Cause

The entire chain of certificates is not imported in both the Portal for ArcGIS and ArcGIS Server admin endpoints. In a distributed environment, this impacts various functionality within the Portal for ArcGIS interface.

Solution or Workaround

Import the root or intermediate certificate to ArcGIS Server and Portal for ArcGIS admin endpoint.

1. Navigate to the Portal for ArcGIS admin endpoint, and log in with an administrator account.
2. Navigate to Security > SSLCertificates, and click Import Root or Intermediate Certificate.
3. Click Choose File, and select the chain of certificates to import. Click Import to begin the import process, and restart Portal for ArcGIS.
4. Navigate to the ArcGIS Server admin endpoint, and log in with an administrator account.
5. Navigate to machines > machine_name >sslcertificates > importRootOrIntermediate.
6. Click Choose File, and select the chain of certificates to import. Click Import to begin the import process, and restart ArcGIS Server.
7. Log in to the ArcGIS Server admin endpoint.
8. Navigate to data > federateDataItem. Enter the item path for the registered data store, and click Federate Data Item.
9. Configure the data store connection.