Ensure that you meet the following prerequisites before you back up the Analysis Center 2.9 databases and run the Data Migration Utility:
There are no pending Data Sources. In the Analysis Center 2.9 Console, right-click each pending Data Source and either activate or remove it.
All the Data Sources are disabled. After the ETL and OLAP processing jobs that are running for each Data Source are complete, use the Analysis Center Console to disable the Data Sources. Close all open 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, reinstall SQL Server. For more information about the collation order, see the Microsoft SQL Server documentation.
The SQL Server account for performing the upgrade has db_owner permissions on the AC_Configuration and AC_Warehouse databases.