managing SSRS 2012 service app in SharePoint 2010 returns 500 Internal Server Error
We're prototyping SSRS 2012 in integrated mode with SharePoint 2010 (single SharePoint server, single DB server). Setup seemed to complete successfully, including provisioning subscriptions and alerts, and setting content types on our report libraries. But... it doesn't work. Opening Central Admin, then my SSRS 2012 application service, then clicking on System Settings throws a 500 Internal Server Error with a correlation ID. I put the trace log into Verbose mode for SharePoint Foundation and SSRS, but it doesn't offer much more information (see log below). Any suggestions on how to go about diagnosing this? Thanks in advance, Quent == LOG == 08/21/2012 08:29:50.13 w3wp.exe (0x04E8) 0x06D8 SharePoint Foundation Logging Correlation Data 77a3 Verbose Starting correlation. 67a55bff-8ac1-484f-8188-bd1da695d5ae 08/21/2012 08:29:50.13 w3wp.exe (0x04E8) 0x06D8 SharePoint Foundation Logging Correlation Data xmnv Medium Name=Request (GET:http://web51dl:12000/_admin/ReportServer/ReportingServicesSystemSettings.aspx?ID=427cf762-5063-42bc-bd56-de03caa893ac) 67a55bff-8ac1-484f-8188-bd1da695d5ae 08/21/2012 08:29:50.13 w3wp.exe (0x04E8) 0x06D8 SharePoint Foundation Monitoring nasq Verbose Entering monitored scope (BeginRequestHandler) 67a55bff-8ac1-484f-8188-bd1da695d5ae 08/21/2012 08:29:50.13 w3wp.exe (0x04E8) 0x06D8 SharePoint Foundation SQM 97qu Verbose SQM: Datapoint id 6693 marked as Increment datapoint. 67a55bff-8ac1-484f-8188-bd1da695d5ae 08/21/2012 08:29:50.13 w3wp.exe (0x04E8) 0x06D8 SharePoint Foundation Monitoring b4ly Verbose Leaving Monitored Scope (BeginRequestHandler). Execution Time=0.0500063555563626 67a55bff-8ac1-484f-8188-bd1da695d5ae 08/21/2012 08:29:50.13 w3wp.exe (0x04E8) 0x06D8 SharePoint Foundation Monitoring nass Verbose ____SQL Query Count=0 67a55bff-8ac1-484f-8188-bd1da695d5ae 08/21/2012 08:29:50.13 w3wp.exe (0x04E8) 0x06D8 SharePoint Foundation Monitoring nass Verbose ____Execution Time=0.0500063555563626 67a55bff-8ac1-484f-8188-bd1da695d5ae 08/21/2012 08:29:50.13 w3wp.exe (0x04E8) 0x06D8 SharePoint Foundation Monitoring nasq Verbose Entering monitored scope (PostAuthenticateRequestHandler) 67a55bff-8ac1-484f-8188-bd1da695d5ae 08/21/2012 08:29:50.13 w3wp.exe (0x04E8) 0x06D8 SharePoint Foundation Runtime 0000 Verbose Value for isAnonymousAllowed is : False 67a55bff-8ac1-484f-8188-bd1da695d5ae 08/21/2012 08:29:50.13 w3wp.exe (0x04E8) 0x06D8 SharePoint Foundation Runtime 0000 Verbose Value for checkAuthenticationCookie is : False 67a55bff-8ac1-484f-8188-bd1da695d5ae 08/21/2012 08:29:50.13 w3wp.exe (0x04E8) 0x06D8 SharePoint Foundation Monitoring b4ly Verbose Leaving Monitored Scope (PostAuthenticateRequestHandler). Execution Time=0.0466539741782824 67a55bff-8ac1-484f-8188-bd1da695d5ae 08/21/2012 08:29:50.13 w3wp.exe (0x04E8) 0x06D8 SharePoint Foundation Monitoring nass Verbose ____SQL Query Count=0 67a55bff-8ac1-484f-8188-bd1da695d5ae 08/21/2012 08:29:50.13 w3wp.exe (0x04E8) 0x06D8 SharePoint Foundation Monitoring nass Verbose ____Execution Time=0.0466539741782824 67a55bff-8ac1-484f-8188-bd1da695d5ae 08/21/2012 08:29:50.13 w3wp.exe (0x04E8) 0x06D8 SharePoint Foundation Logging Correlation Data xmnv Medium User=NCCI\APFQH 67a55bff-8ac1-484f-8188-bd1da695d5ae 08/21/2012 08:29:50.13 w3wp.exe (0x04E8) 0x06D8 SharePoint Foundation Monitoring nasq Verbose Entering monitored scope (PostResolveRequestCacheHandler) 67a55bff-8ac1-484f-8188-bd1da695d5ae 08/21/2012 08:29:50.13 w3wp.exe (0x04E8) 0x06D8 SharePoint Foundation Monitoring b4ly Verbose Leaving Monitored Scope (PostResolveRequestCacheHandler). Execution Time=0.00698412787100036 67a55bff-8ac1-484f-8188-bd1da695d5ae 08/21/2012 08:29:50.13 w3wp.exe (0x04E8) 0x06D8 SharePoint Foundation Monitoring nass Verbose ____SQL Query Count=0 67a55bff-8ac1-484f-8188-bd1da695d5ae 08/21/2012 08:29:50.13 w3wp.exe (0x04E8) 0x06D8 SharePoint Foundation Monitoring nass Verbose ____Execution Time=0.00698412787100036 67a55bff-8ac1-484f-8188-bd1da695d5ae 08/21/2012 08:29:50.13 w3wp.exe (0x04E8) 0x06D8 SharePoint Foundation General 6t8b Verbose Looking up context site http://web51dl:12000/_admin/ReportServer/ReportingServicesSystemSettings.aspx?ID=427cf762-5063-42bc-bd56-de03caa893ac in the farm MOS_ProjectServer_SharePoint_Config 67a55bff-8ac1-484f-8188-bd1da695d5ae 08/21/2012 08:29:50.13 w3wp.exe (0x04E8) 0x06D8 SharePoint Foundation General 6t8d Verbose Looking up the additional information about the typical site http://web51dl:12000/_admin/ReportServer/ReportingServicesSystemSettings.aspx?ID=427cf762-5063-42bc-bd56-de03caa893ac. 67a55bff-8ac1-484f-8188-bd1da695d5ae 08/21/2012 08:29:50.13 w3wp.exe (0x04E8) 0x06D8 SharePoint Foundation General 6t8f Verbose Site lookup is replacing http://web51dl:12000/_admin/ReportServer/ReportingServicesSystemSettings.aspx?ID=427cf762-5063-42bc-bd56-de03caa893ac with the alternate access url http://web51dl:12000. 67a55bff-8ac1-484f-8188-bd1da695d5ae 08/21/2012 08:29:50.13 w3wp.exe (0x04E8) 0x06D8 SharePoint Foundation General 6t8g Verbose Looking up typical site http://web51dl:12000/_admin/ReportServer/ReportingServicesSystemSettings.aspx?ID=427cf762-5063-42bc-bd56-de03caa893ac in web application SPAdministrationWebApplication. 67a55bff-8ac1-484f-8188-bd1da695d5ae 08/21/2012 08:29:50.13 w3wp.exe (0x04E8) 0x06D8 SharePoint Foundation General 6t8h Verbose Found typical site / (09f438d0-ffaa-414a-a523-519e226d2b42) in web application SPAdministrationWebApplication. 67a55bff-8ac1-484f-8188-bd1da695d5ae 08/21/2012 08:29:50.15 w3wp.exe (0x04E8) 0x06D8 SharePoint Foundation Logging Correlation Data xmnv Medium Site=/ 67a55bff-8ac1-484f-8188-bd1da695d5ae 08/21/2012 08:29:50.15 w3wp.exe (0x04E8) 0x06D8 SharePoint Foundation Database tkeb Verbose Setting database session for {1deabf3d-7634-4bdb-bc00-e2489c22faef}. 67a55bff-8ac1-484f-8188-bd1da695d5ae 08/21/2012 08:29:50.15 w3wp.exe (0x04E8) 0x06D8 SharePoint Foundation Database tzku Verbose ConnectionString: 'Data Source=DBS20di\ins2;Initial Catalog=SharePoint_AdminContent_bf437be3-4bbe-4535-8c38-e958cf28252a;Integrated Security=True;Enlist=False;Asynchronous Processing=False;Connect Timeout=15' ConnectionState: Closed ConnectionTimeout: 15 67a55bff-8ac1-484f-8188-bd1da695d5ae 08/21/2012 08:29:50.15 w3wp.exe (0x04E8) 0x06D8 SharePoint Foundation Database tzku Verbose ConnectionString: 'Data Source=DBS20di\ins2;Initial Catalog=SharePoint_AdminContent_bf437be3-4bbe-4535-8c38-e958cf28252a;Integrated Security=True;Enlist=False;Asynchronous Processing=False;Connect Timeout=15' ConnectionState: Closed ConnectionTimeout: 15 67a55bff-8ac1-484f-8188-bd1da695d5ae 08/21/2012 08:29:50.15 w3wp.exe (0x04E8) 0x06D8 SharePoint Foundation Database tzku Verbose ConnectionString: 'Data Source=DBS20di\ins2;Initial Catalog=SharePoint_AdminContent_bf437be3-4bbe-4535-8c38-e958cf28252a;Integrated Security=True;Enlist=False;Asynchronous Processing=False;Connect Timeout=15' ConnectionState: Closed ConnectionTimeout: 15 67a55bff-8ac1-484f-8188-bd1da695d5ae 08/21/2012 08:29:50.15 w3wp.exe (0x04E8) 0x06D8 SharePoint Foundation General 6t8b Verbose Looking up context site http://web51dl:12000/_admin/ReportServer/ReportingServicesSystemSettings.aspx?ID=427cf762-5063-42bc-bd56-de03caa893ac in the farm MOS_ProjectServer_SharePoint_Config 67a55bff-8ac1-484f-8188-bd1da695d5ae 08/21/2012 08:29:50.15 w3wp.exe (0x04E8) 0x06D8 SharePoint Foundation General 6t8d Verbose Looking up the additional information about the typical site http://web51dl:12000/_admin/ReportServer/ReportingServicesSystemSettings.aspx?ID=427cf762-5063-42bc-bd56-de03caa893ac. 67a55bff-8ac1-484f-8188-bd1da695d5ae 08/21/2012 08:29:50.15 w3wp.exe (0x04E8) 0x06D8 SharePoint Foundation General 6t8f Verbose Site lookup is replacing http://web51dl:12000/_admin/ReportServer/ReportingServicesSystemSettings.aspx?ID=427cf762-5063-42bc-bd56-de03caa893ac with the alternate access url http://web51dl:12000. 67a55bff-8ac1-484f-8188-bd1da695d5ae 08/21/2012 08:29:50.15 w3wp.exe (0x04E8) 0x06D8 SharePoint Foundation General 6t8g Verbose Looking up typical site http://web51dl:12000/_admin/ReportServer/ReportingServicesSystemSettings.aspx?ID=427cf762-5063-42bc-bd56-de03caa893ac in web application SPAdministrationWebApplication. 67a55bff-8ac1-484f-8188-bd1da695d5ae 08/21/2012 08:29:50.15 w3wp.exe (0x04E8) 0x06D8 SharePoint Foundation General 6t8h Verbose Found typical site / (09f438d0-ffaa-414a-a523-519e226d2b42) in web application SPAdministrationWebApplication. 67a55bff-8ac1-484f-8188-bd1da695d5ae 08/21/2012 08:29:50.15 w3wp.exe (0x04E8) 0x06D8 SharePoint Foundation Unified Logging Service 854l Verbose refreshing throttle cache for SPRSDiagnosticsService, 22949cb0-4d24-42cd-8163-34255c07827d 67a55bff-8ac1-484f-8188-bd1da695d5ae 08/21/2012 08:29:50.15 w3wp.exe (0x04E8) 0x06D8 SQL Server Reporting Services Service Application Proxy 0000 Verbose Constructing a new service application proxy using default constructor. 67a55bff-8ac1-484f-8188-bd1da695d5ae 08/21/2012 08:29:50.18 w3wp.exe (0x04E8) 0x06D8 SharePoint Foundation Monitoring nasq Verbose Entering monitored scope (CreateChannelActingAsLoggedOnUser:Microsoft.ReportingServices.ServiceContract.IReportServiceManagement) 67a55bff-8ac1-484f-8188-bd1da695d5ae 08/21/2012 08:29:50.18 w3wp.exe (0x04E8) 0x06D8 SharePoint Foundation Monitoring nasq Verbose Entering monitored scope (GetServiceSecurityToken) 67a55bff-8ac1-484f-8188-bd1da695d5ae 08/21/2012 08:29:50.18 w3wp.exe (0x04E8) 0x06D8 SharePoint Foundation Monitoring b4ly Verbose Leaving Monitored Scope (GetServiceSecurityToken). Execution Time=0.0441396881447223 67a55bff-8ac1-484f-8188-bd1da695d5ae 08/21/2012 08:29:50.18 w3wp.exe (0x04E8) 0x06D8 SharePoint Foundation Monitoring nass Verbose ____Execution Time=0.0441396881447223 67a55bff-8ac1-484f-8188-bd1da695d5ae 08/21/2012 08:29:50.18 w3wp.exe (0x04E8) 0x06D8 SharePoint Foundation Monitoring nasq Verbose Entering monitored scope (CreateChannelWithIssuedToken) 67a55bff-8ac1-484f-8188-bd1da695d5ae 08/21/2012 08:29:50.18 w3wp.exe (0x04E8) 0x06D8 SharePoint Foundation Monitoring b4ly Verbose Leaving Monitored Scope (CreateChannelWithIssuedToken). Execution Time=3.846857631347 67a55bff-8ac1-484f-8188-bd1da695d5ae 08/21/2012 08:29:50.18 w3wp.exe (0x04E8) 0x06D8 SharePoint Foundation Monitoring nass Verbose ____Execution Time=3.846857631347 67a55bff-8ac1-484f-8188-bd1da695d5ae 08/21/2012 08:29:50.18 w3wp.exe (0x04E8) 0x06D8 SharePoint Foundation Monitoring b4ly Verbose Leaving Monitored Scope (CreateChannelActingAsLoggedOnUser:Microsoft.ReportingServices.ServiceContract.IReportServiceManagement). Execution Time=3.98011479112569 67a55bff-8ac1-484f-8188-bd1da695d5ae 08/21/2012 08:29:50.18 w3wp.exe (0x04E8) 0x06D8 SharePoint Foundation Monitoring nass Verbose ____Execution Time=3.98011479112569 67a55bff-8ac1-484f-8188-bd1da695d5ae 08/21/2012 08:29:50.18 w3wp.exe (0x04E8) 0x06D8 SharePoint Foundation Topology e5mc Medium WcfSendRequest: RemoteAddress: 'http://web51dl:32843/427cf762506342bcbd56de03caa893ac/ReportingWebService.svc' Channel: 'Microsoft.ReportingServices.ServiceContract.IReportServiceManagement' Action: 'http://schemas.microsoft.com/sqlserver/reporting/2011/06/01/ReportServer/Management/GetSystemProperties' MessageId: 'urn:uuid:aaffab18-5f2a-47de-9a70-75d0ef5f00ae' 67a55bff-8ac1-484f-8188-bd1da695d5ae 08/21/2012 08:29:50.18 w3wp.exe (0x04E8) 0x06D8 SharePoint Foundation Monitoring nasq Verbose Entering monitored scope (InitializeWcfOperation) 67a55bff-8ac1-484f-8188-bd1da695d5ae 08/21/2012 08:29:50.18 w3wp.exe (0x04E8) 0x06D8 SharePoint Foundation Monitoring b4ly Verbose Leaving Monitored Scope (InitializeWcfOperation). Execution Time=0.0145269859716808 67a55bff-8ac1-484f-8188-bd1da695d5ae 08/21/2012 08:29:50.18 w3wp.exe (0x04E8) 0x06D8 SharePoint Foundation Monitoring nass Verbose ____Execution Time=0.0145269859716808 67a55bff-8ac1-484f-8188-bd1da695d5ae 08/21/2012 08:29:50.18 w3wp.exe (0x04E8) 0x06D8 SharePoint Foundation Monitoring nasq Verbose Entering monitored scope (ExecuteWcfOperation:http://schemas.microsoft.com/sqlserver/reporting/2011/06/01/ReportServer/Management/GetSystemProperties) 67a55bff-8ac1-484f-8188-bd1da695d5ae 08/21/2012 08:29:50.18 w3wp.exe (0x04E8) 0x06D8 SharePoint Foundation General 8nca Verbose Application error when access /_admin/ReportServer/ReportingServicesSystemSettings.aspx, Error=The remote server returned an error: (500) Internal Server Error. at System.Net.HttpWebRequest.GetResponse() at System.ServiceModel.Channels.HttpChannelFactory.HttpRequestChannel.HttpChannelRequest.WaitForReply(TimeSpan timeout) 67a55bff-8ac1-484f-8188-bd1da695d5ae 08/21/2012 08:29:50.18 w3wp.exe (0x04E8) 0x06D8 SharePoint Foundation Runtime tkau Unexpected System.Net.WebException: The remote server returned an error: (500) Internal Server Error. at System.Net.HttpWebRequest.GetResponse() at System.ServiceModel.Channels.HttpChannelFactory.HttpRequestChannel.HttpChannelRequest.WaitForReply(TimeSpan timeout) 67a55bff-8ac1-484f-8188-bd1da695d5aeQuent
August 21st, 2012 8:38am

Hi Quent, Thanks for posting on TechNet forum. Based on the error message "The remote server returned an error: (500) Internal Server Error", the issue may be caused by that the Anonymous Access is enabled for the SharePoint Web Application that is associated with the SQL Server Reporting Services Application. To resolve the issue, please refer to the detailed steps in the following blog: Enable Anonymous Access in SharePoint 2010 If you have any questions, please feel free to let me know. Regards, Mike Yin TechNet Subscriber Support If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.Mike Yin TechNet Community Support
Free Windows Admin Tool Kit Click here and download it now
August 23rd, 2012 6:45am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics