Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to recover lost master key? Expand / Collapse
Author
Message
Posted Saturday, February 25, 2012 3:20 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Saturday, February 25, 2012 4:59 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 1:49 PM
Points: 32,768, Visits: 14,929
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
Posted Sunday, February 26, 2012 12:00 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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 »

Add to briefcase

Permissions Expand / Collapse