Move SSAS Databases 2008 R2 to 2012
Posted on 2014-07-18
I am moving SQL Server Analysis Services databases from SQL Server 2008 R2 64-Bit Standard Edtion to SQL Server 2012 64-Bit Standard Edition. The databases are moving from one physical server to another physical server. Here's the problem.
I backed up an SSAS database on 2008 R2 server, password protected. I copied the backup file (ABF) to the 2012 server. On the 2012 server I open the SSAS instance, right-click the Databases folder and choose Restore... from the menu. I select the ABF 'Backup file', enter the 'Restore database' name and enter the password I used. 'Allow database overwrite' is unchecked, 'Include security information' is set to Copy All.
When I click OK, I receive a message:
"Errors related to feature availability and configuration: The 'Support of ReadOnly databases' feature is not included in the '64 Bit Standard' edition of Analysis Services. (Microsft.AnalysisServices)"
What can I do to overcome this error?