Errors in the encryption library: Failed to encrypt sensitive data. Possibly the encryption key is inaccessible because of impro
Question
Thursday, April 3, 2008 9:34 AM
Hi Experts,
While I was processing my CUBE, it prompts me this error:
Errors in the encryption library: Failed to encrypt sensitive data. Possibly the encryption key is inaccessible because of improper service account change.
it is deployed on SQL Server 2005 developer edition with SP2 which support Window Vista Ultimate.
Can anyone fix this?
Regards,
Chris
All replies (8)
Thursday, April 3, 2008 9:53 AM ✅Answered
Hi,
I have fixed the problem by deleting the Analysis Services database and re-process it.
Apparently, the existing AS database does not allow me to overwrite it while I process the cube. So it generated the error above.
Besides, deleting the database and reprocess it .. is there a way to counter the error?
Appreciate your help.
Regards,
Chris
Friday, April 4, 2008 11:52 PM
Did you change the Logon account for the SQL Server Analysis Services instance after creating the previous database?The database stores are encrypted using the account info and the same key is used for storing files when you process the cube - if you changed the account before you processed the cube, the stored key will not be usable for encypting the cube data.
Saturday, April 5, 2008 2:50 AM
Thanks for the reply Raman,
However, my memory tells me that I didnt change the logon account. Here is what I do :-
1.) I did delete the existing data mining structure and cube and recreated it again in BIDS. Will the new cube conflict with the existing cube which presented in SQL Server AS?
Best Regards,
Chris
Sunday, March 21, 2010 4:18 PM | 3 votes
Solved.
Delete the contents of the following folder (take a backup in case...)
C:\Program Files\Microsoft SQL Server\MSAS10.MSSQLSERVER\OLAP\Data\BAMAnalysis.0.db
Restart SQL Analysis service
if it does not work then copy 0.CryptKey.bin under above path
And again restart the SQL Analysis service
It worked with me.
Cheers
Shaik
Thursday, April 8, 2010 3:00 PM | 2 votes
Yes, the above works with SSAS 2008. My experience:
1. Stop SSAS service
2. Make backup of project: C:\Program Files\Microsoft SQL Server\MSAS10.MSSQLSERVER\OLAP\Data\MyProject.0.db
3. Delete SSAS database. So delete contents of C:\Program Files\Microsoft SQL Server\MSAS10.MSSQLSERVER\OLAP\Data\MyProject.0.db directory.
4. Copy 0.CryptKey.bin file from backup to C:\Program Files\Microsoft SQL Server\MSAS10.MSSQLSERVER\OLAP\Data\MyProject.0.db
5. Start SSAS service and deplot/process your cube again using BIDS.
Tuesday, May 10, 2011 3:54 PM
Thanks - above worked for me too using SSAS 2008.
Sunday, June 3, 2012 2:14 AM | 1 vote
after you delete the "My SSAS Project.0.db" folder from the project data folder "..Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Data\,
you can also delete the "My SSAS Project.0.db.xml" from the project data folder "..Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Data\
this way you do not have to deal with not finding "CryptKey.bin" problem.
Saturday, June 16, 2012 1:06 PM
These answers really helped restore my production environement , thanks all for your input.
I never encoutered these issues in the past until I started implementing the Data Mining phase of the project, and now it keeps on happening and I am wondering if these issues are not inheritent to a configuration param... because it will realy give my current B.I project a black eye if it keeps on loosing the CryptKey
Jio