2014 SP2:Archive database upgrade fails with error
Symptoms
When trying to upgrade the archive database from 2012 to 2014 SP2, the following error is generated in the log:
Could not detect a valid Changepoint Web.Config user
Reason
Configuration, the Changepoint web user did not exist in the database.
Resolution
Ran the following against the main Changepoint DB:
EXEC DBM_EnableSqlDependency
EXEC DBM_SetupCPTempDB
EXEC DBM_SetupCPExtended
Then performed the upgrade once again.