Before backing up the databases and using the Data Migration Utility, verify the following information:
There are no pending Data Sources. Right-click each pending Data Source in the Analysis Center Console, and select either Create or Remove.
All the Data Sources are disabled. After the ETL and OLAP Processing jobs that are running for each Data Source are complete, disable the Data Sources using the Analysis Center Console. Then close all Analysis Center Consoles.
The collation order of the source SQL Server computer (that contains the current version of the Analysis Center databases) and the target SQL Server computer (for the newer version of Analysis Center databases) is the same. You can define the SQL Server collation order when you install SQL Server. The default collation order is based on the locale setting of the operating system. You cannot change the collation order after installation. If the collation orders do not match, re-install SQL Server. For more information about the collation order, see the Microsoft SQL Server documentation.
The SQL Server account performing the upgrade has db_owner permissions on the AC_Configuration and AC_Warehouse databases.