Thursday, February 9, 2017

Errors in the encryption library: Failed to encrypt sensitive data.

After upgrading to SQL Server 2016 I got into trouble. As I tried to use the Analysis Services cubes I got the following error message:

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

I was able to fix it by removing the existing datawarehouse and rebuilt the datawarehouse from scratch.

No comments: