Errors in the encryption library: Failed to encrypt sensitive data. Possibly the encryption key is inaccessible because of improper service account change.


Problem:

Encounter the error as shown in the titile when processing a cube.

Solution:


  1. Stop the SSAS service
  2. Make a backup of the project: C:\Program Files\Microsoft SQL Server\MSAS10.MSSQLSERVER\OLAP\Data\TK 448 Mining Models Project.0.db
  3. Delete SSAS database, that is, delete the contents of C:\Program Files\Microsoft SQL Server\MSAS10.MSSQLSERVER\OLAP\Data\TK 448 Mining Models Project.0.db directory.
  4. Delete the "TK 448 Mining Models Project.0.db.xml" from the project data folder "..Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Data\"
  5. Start the SSAS service again and deploy/process your cube again using BIDS.