This is due to the database settings on Analysis Services on SQL Server. The message will appear of something has changed on the database so that it no longer allows overwrites. If the Logon account for the SQL Server Analysis Services instance is changed after creating the database, the stored key is unusable for encrypting your cube data. To solve this, you must delete the company and Analysis services database and create a new data warehouse, or: - Stop the SQL Server Analysis Service.
- Take a backup of the project: C:\Program Files\Microsoft SQL Server\MSAS10.MSSQLSERVER\OLAP\Data\MyProject.0.db
- Delete the Analysis Services database, i.e. delete the contents of C:\Program Files\Microsoft SQL Server\MSAS10.MSSQLSERVER\OLAP\Data\MyProject.0.db directory.
- Copy 0.CryptKey.bin file from your backup, to C:\Program Files\Microsoft SQL Server\MSAS10.MSSQLSERVER\OLAP\Data\MyProject.0.db
- Start SQL Server Analysis Services.
You will be able to process your BI cubes from the BI System Administrator. |