I am trying to set up SSRS, PowerPivot, SharePoint, etc. on a single VM. I have everything loaded and running except that I can't create the SSRS Service Application in Central Administration. I have seen all kinds of checklists and step-by-step instructions and I believe I have followed them. When I try to create a Power View report, I get the error that SSRS is not set up. In CA, there is no SSRS Service Application (the SSRS service is running on the server however).
When I attempt to create the service, the message I get is this:
Key not valid for use in specified state. (Exception from HRESULT: 0x8009000B)
Based on my research, this looks like a problem with the SSRS key used to encrypt information in the database. But I haven't created the database yet. That's one of the things that is supposed to be happening!
Please Help, Thanks,
Tuesday, March 06, 2012 8:44 PM
- Edited by Steve Wright [Omaha] Tuesday, March 06, 2012 8:45 PM
check these links for configuring power view. I have followed and executed successfully.
Please mark as answer if helpfulWednesday, March 07, 2012 4:43 AM
Thanks, but I have followed all of those procedures and it still won't create the SSRS service application. I completely removed SharePoint and SQL 2012 RC0. I downloaded the RTM bits yesterday and used those when I reinstalled. I ran into the exact same problem!
Does anyone have an idea?
SteveThursday, March 08, 2012 4:54 PM
Using ULSViewer, I was able to get this stack trace for the problem. Hopefully, it will help.
Unexpected error occurred when creating Reporting Service Application My RS Service App: System.Runtime.InteropServices.COMException (0x8009000B): Key not valid for use in specified state. (Exception from HRESULT: 0x8009000B)
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at Microsoft.SharePoint.Utilities.SecurityContext.RunAsProcess(CodeToRunElevated secureCode)
at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(WaitCallback secureCode, Object param)
at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(CodeToRunElevated secureCode)
at Microsoft.ReportingServices.SharePoint.SharedService.Service.ReportingWebServiceApplication.GenerateEncryptionKey(ReportingWebServiceApplication serviceApp)
at Microsoft.ReportingServices.SharePoint.SharedService.Service.ReportingWebServiceApplication..ctor(String name, ReportingWebService service, SPIisWebServiceApplicationPool applicationPool, ReportingServiceDatabase catalogDatabase, ReportingServiceTempDatabase tempDatabase, ReportingServiceAlertingDatabase alertingDatabase)
at Microsoft.ReportingServices.SharePoint.SharedService.Service.ReportingWebServiceApplication.Create(String name, ReportingWebService service, SPIisWebServiceApplicationPool applicationPool, ReportingServiceDatabase catalogDatabase, ReportingServiceTempDatabase tempDatabase, ReportingServiceAlertingDatabase alertingDatabase, RSAccountCredentials unattendedExecAccount, RSAccountCredentials windowsDatabaseCredentials)
at Microsoft.ReportingServices.SharePoint.PowerShell.NewReportingServiceApplication.CreateDataObject().Thursday, March 08, 2012 7:58 PM
Can you check what are the permissions of the account you specified for the application pool when you tried to create the Shared Service Application, also try with a different account.
This posting is provided "AS IS" with no warranties, and confers no rights
Friday, March 09, 2012 7:18 PM