How to recover lost master key?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Performance Point » How to recover lost master key?

How to recover lost master key?

Rate Topic

Display Mode

Topic Options

Author

Message

tandrei

Posted Saturday, February 25, 2012 3:20 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, July 16, 2012 1:14 AM
Points: 5, Visits: 19

Hello,
We have recently took up some new machines with SP and PP based solution. After a power outage... the server logs show up lots of errors like "PerformancePoint services was unable to retrieve the Unattended Service Account password from the Secure Store. Error Details:" and of course our BI page is down.
Since I am a noob on this technology, I must get up the BI page asap.
Until now I have tried:
- create a new master key for secure service - failed with error Exception of type 'Microsoft.Office.SecureStoreService.Server.KeyManagement.InvalidMasterKeyException' was thrown.
- unable to refresh the old master key, because the password is lost
- set the unattended execution account for the PP service application - also unsuccessful because of the master key retrieve error.
I have read MS article explaining how to get rid of the error, but noone tells you what to do if you don't have your initial phrase. Is it possible to delete this masterkey so I could create a new one, because I suspect one of the reasons I can't create a new one is that the prev. one still exists.

I would appreciate your answers as situation began to escalate and mgmgt wants immediate results:)

regards,
andrei turcu
BI developer HP Software
Cluj, romania

Post #1257874

Steve Jones - SSC Editor

Posted Saturday, February 25, 2012 4:59 PM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 5:09 AM
Points: 31,526, Visits: 13,864

If you've read a KB article, it would be good to post the # here so we know what you've done.

Is this a master key in SQL Server or is there one in Sharepoint/Powerpoint (I'm not familiar with those).

If it's in SQL Server, if this was the service master key, I think you might be stuck. Do you have master key passwords for the individual databases? Does this potentially help? http://blogs.msdn.com/b/lcris/archive/2007/11/14/sql-server-2005-how-to-recover-when-the-service-master-key-smk-is-not-accessible.aspx

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #1257880

tandrei

Posted Sunday, February 26, 2012 12:00 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, July 16, 2012 1:14 AM
Points: 5, Visits: 19

the article is http://technet.microsoft.com/en-us/library/ee924660.aspx
This is not MS SQL Server, it is a "secure store service" masterkey.

Post #1257903

« Prev Topic | Next Topic »

Permissions