Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Analysis Services database RESTORE issue


Analysis Services database RESTORE issue

Author
Message
ali_a_asgari
ali_a_asgari
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 Visits: 269
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
Rick Todd
SSC Veteran
SSC Veteran (222 reputation)SSC Veteran (222 reputation)SSC Veteran (222 reputation)SSC Veteran (222 reputation)SSC Veteran (222 reputation)SSC Veteran (222 reputation)SSC Veteran (222 reputation)SSC Veteran (222 reputation)

Group: General Forum Members
Points: 222 Visits: 441
Did you look at this: http://support.microsoft.com/kb/956377
?
Cheers,


Rick Todd
ali_a_asgari
ali_a_asgari
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 Visits: 269
Yes, I already have SQL Server 2005 Service Pack 3 on the sever.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search