"Unable to configure component: Unable to validate CSI_DATA SQL instance" when running maintenance in ConnectShip Progistics Management Console for SendSuite Live

Print this support article
Products affected: SendSuiteĀ® Live

Issue

When running maintenance in ConnectShip Progistics Management Console, the following error is displayed:

"The following errors were encountered:

ConnectShip UPS (Consolidated): Unable to configure component:

Unable to validate CSI_DATA SQL instance"

Cause

The "Transaction Data" and "Configuration Data" Connection Strings are improperly configured or are set to not be used.

Resolution

  1. Launch Progistics Management Console as Administrator.
  2. On the left side, navigate to Server Components.
  3. Double-click on ConnectShip UPS (Consolidated) to open the editor.
  4. Click on the Transaction Data tab.
  5. Ensure that the Location is set to SQL Server.
  6. Ensure the Database connection string matches the following format and contains valid values for all fields:
 server=[SERVER INSTANCE];database=[DATABASE NAME];user id=[SQL USERNAME];password=[SQL PASSWORD];
  1. Click on the Configuration Data tab.
  2. Ensure that the Location is set to SQL Server.
  3. Ensure that the Database connection string matches the following format and contains valid values for all fields:
 server=[SERVER INSTANCE];database=[DATABASE NAME];user id=[SQL USERNAME];password=[SQL PASSWORD];
  1. Save your changes in the lower right corner.

Test Criteria

Attempt to run maintenance again. If it succeeds, the resolution worked.

Permissions Required

Windows Administrator

UPDATED: August 14, 2021