Upgrading a central ACM database
After installing a new version of ACM, the database may sometimes require upgrading due to the adding of new tables or fields. You will be notified to upgrade the database if applicable.
The failure of the upgrade process could be related to you having insufficient permissions of the central server to execute the upgrade commands. The upgrade process could also fail due to the requirement of additional prerequisite software needed on the SQL server host machine.
If upgrading ACM from v2.xx to v4.xx and later, this error is likely due to the x64 versions of the following components not being installed:
- Microsoft System CLR Types for SQL Server 2012 (x64)
- Microsoft SQL Server 2012 Management Objects (x64)
It is recommended that when installing a new version of ACM on a client machine on which the same version of ACM is also installed on the SQL server host machine to ensure that all prerequisite software is also installed.
Provide Feedback