PSIcapture: The database 'Capture_Configuration' cannot be opened because it is version 782. This server supports version 706 and earlier.

Problem

The following error message is displayed due to a mismatch in the SQL server versions. PSIcapture uses the SQL LocalDB for configuration, batches, etc. It uses SQL 2012 for this purpose. However, attaching the DB to anything above 2012 performs a auto SQL upgrade procedure.

Capture.Services error message:

The following exception(s) occurred loading the Configuration service.

The following error(s) occurred: The database 'Capture_Configuration' cannot be opened because it is version 782. This server supports version 706 and earlier. A downgrade path is not supported.

Solution

The SQL LocalDB has been modified and cannot be rolled back. The customer will need to restore a backup from before the config DB was attached to 2014 or higher.