Keyset does not exist (Exception from HRESULT: 0x80090016)
I am new to SSRS! I have SQL Server 2008 on Windows XP SP2 installed locally for my testing. I created a first report and deployed it successfully. But then when I tried to access the reports using http://localhost:8080/reportsor the ReportServer URLs, I kept on getting a login dialog which did not let mepass this point no matter what password I tried. Inan effort tosolve this problem, Iread on the Internet that this problem might be solvedifI changedmy service account to Network Service instead. So using the configuration tool, I changed it and gave the tool a file and a password to store the keys. That did not work ...so I decided to change the service account back to Local Service as it was. This is when ____ broke lose....now any attempt I make to change the service account or even delete the whole thing (using the config tool -> Encryption Keys), I get the same failure:Microsoft.ReportingServices.WmiProvider.WMIProviderException: Keyset does not exist (Exception from HRESULT: 0x80090016) at Microsoft.ReportingServices.WmiProvider.RSWmiAdmin.ThrowOnError(ManagementBaseObject mo) at Microsoft.ReportingServices.WmiProvider.RSWmiAdmin.DeleteEncryptedInformation() at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.DeleteEncryptedInformation()Please help me....I really appreciate any pointer. Thanks in advance.Regards,Towba
September 11th, 2009 4:53pm
I was able to get rid of this by stopping the SSRS service from the configuration tool and then dropped the SSRS databases (ReportServer and ReportServerTempDB) manually using the MSS Management Studio. Then I restarted the SSRS service. This seems to have force an SSRSserver re-initilzaition which cleared the error. I still have the LOGIN dialog appearing and will not let me go pass it though. So any help in this is still very much appreciated. Regards,Towba
Free Windows Admin Tool Kit Click here and download it now
September 11th, 2009 9:51pm
You issue is probably security related. See if the following helps:Go to your local IIS manager. Select Web Sites -> ReportServer. Right click on it and select properties. Chose the Directory Security tab and select Edit on Authentication and access control. Make sure that Enable anonymous access is checked.Hope this helps,--Josh
September 11th, 2009 10:23pm
Thank you for your answer. But I am running SSRS 2008...I thought it does not rely on IIS and that it has a built-in web server!Regards,Towba
Free Windows Admin Tool Kit Click here and download it now
September 12th, 2009 3:51pm
Hi Towba,
From the error message, the issue should be caused by the WMI configuration for Report Services has been corrupted.
Please use the following steps to repair the WMI configuration:
1. Open the SQL Server Report Server folder.
<Install Driver>:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer
2. Open the bin folder.
3. Copy and rename the file reportingservices.mof
4. Register the file using the following command
Mofcomp <Install Driver>:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\bin\reportingservices.mof
If the solution does not help, please follow these steps after:
1. Make sure the Reporting Services windows service is running using SQL Server Configuration Manager.
2. Using Reporting Services Configuration Manager to change the service account to Local system
3. Reapply the database task by clicking the change database option
4. Make sure the webservice URL IP address and TCP IP was fine.
5. Do wbem test(Run the command wbemtest) and and type: \\.\root\microsoft\sqlserver\reportserver(In the connect to windows, type the address.)
6. Press Query... button
7. Type Select * from __namespace and then pressed Apply. Check if the Reporting Services instance is returned.
8. Give logged in account full permission after clicking on security for Report Server folder under root.
By default, the folder locates at:
C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer
9. Checked rsreportserver.config to see if there is any incorrectly modified.
For you first questions, that should be a Kerberos issue, please read the following article for more information about this issue:
http://blogs.msdn.com/lukaszp/archive/2008/07/18/reporting-services-http-401-unauthorized-host-headers-require-your-attention.aspx
Please feel free to ask, if you have any more questions.
Thanks,
Jin ChenJin Chen - MSFT
September 14th, 2009 9:22am
ahhhhhh changing my iis port to 81 fixed this - conflict of ports NICE WORK JIN CHEN MY MAN!!!!!!!!!!!!!!!!!!!
Free Windows Admin Tool Kit Click here and download it now
November 25th, 2010 12:23pm
Hi Jin Chen,
I meet the problems like towba's. I read your help carefully. And do that step by step.
I./. According to your first solution:
1. Copy file reportingservices.mof in bin folder -> Paste in its selft -> Rename to "reportingservices2.mof".
2. Run cmd command: And type command as follow:
C:\Mofcomp C: \Program Files\Microsoft SQL Server\MSRS10.
MSSQLSERVER2008
\Reporting Services\ReportServer\bin\reportingservices.mof
Its result is help window, show:
C:\>mofcomp C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER2008\Reporting Services\ReportServer\bin\reportingservices.mof
Microsoft (R) 32-bit MOF Compiler Version 5.1.2600.2180
Copyright (c) Microsoft Corp. 1997-2001. All rights reserved.
usage: mofcomp [-check] [-N:<Path>]
[-class:updateonly|-class:createonly]
[-instance:updateonly|-instance:createonly]
[-B:<filename>] [-P:<Password>] [-U:<UserName>]
[-A:<Authority>] [-WMI] [-AUTORECOVER]
[-MOF:<path>] [-MFL:<path>] [-AMENDMENT:<Locale>]
[-ER:<ResourceName>] [-L:<ResourceLocale>]
<MOF filename>
-check Syntax check only
-N:<path> Load into this namespace by default
-class:updateonly Do not create new classes
-class:safeupdate Update unless conflicts exist
-class:forceupdate Update resolving conflicts if possible
-class:createonly Do not change existing classes
-instance:updateonly Do not create new instances
-instance:createonly Do not change existing instances
-U:<UserName> User Name
-P:<Password> Login password
-A:<Authority> Example: NTLMDOMAIN:Domain
-B:<destination filename> Creates a binary MOF file, does not add to DB
-WMI Do Windows Driver Model (WDM) checks, requires -B switch
-AUTORECOVER Adds MOF to list of files compiled during DB recovery
-Amendment:<LOCALE> splits MOF into language neutral and specific versions
where locale is of the form "MS_4??"
-MOF:<path> name of the language neutral output
-MFL:<path> name of the language specific output
-ER:<ResourceName> extracts binary mof from named resource
-L:<ResourceLocale> optional specific locale number when using -ER switch
Example c:>mofcomp -N:root\default yourmof.mof
I don't know where the command is wrong.
II./. According to your second solution, I do step by step:
1. Run: Reporting Services Configuration Manager
2. Select Service Account ->
change the service account to Local system -> Click apply button -> It show "Backup Encryption Key" window again.
-> I can't do next step
Please tell me How I do wrong.
Thanks.
November 27th, 2010 8:19am
Hi towba,
Do you fix that error? And How do you do to ignore "Authentication required" dialog window that require "User name" and "Password".
Thanks.
Free Windows Admin Tool Kit Click here and download it now
November 27th, 2010 8:24am