Analysis Services database RESTORE issue

• ali_a_asgari

  Old Hand

  Points: 338

  More actions

  April 25, 2010 at 10:43 pm

  #223922

  Hi friends,

  I'm getting the bellow error while trying to RESTORE a sql server 2005 analysis services database BACKUP

  What could be the reason.?

  Thanks & Regards,

  File system error: The following error occurred while opening the file '\\?\M:\Microsoft SQL Server\MSSQL.5\OLAP\Data\fl_cubes_20100423.113.db\0.CryptKey.bin'.

  Errors in the metadata manager. Processing for the database will be disabled because an error occurred while loading the 'fl_cubes_20100423' database cryptography key. One possible reason for this error is that the service account has changed.

  Errors in the encryption library: Failed to decrypt sensitive data. Possibly the encryption key does not match or is inaccessible because of improper service account change.

  (Microsoft.AnalysisServices)

• Rick Todd

  Hall of Fame

  Points: 3302

  More actions

  April 26, 2010 at 9:43 am

  #1157706

  Did you look at this: http://support.microsoft.com/kb/956377

  ?

  Cheers,

  
  Rick Todd

• ali_a_asgari

  Old Hand

  Points: 338

  More actions

  April 26, 2010 at 12:25 pm

  #1157792

  Yes, I already have SQL Server 2005 Service Pack 3 on the sever.