RDL Rendering (500 Internal Server) Error at Sharepoint Integrated Reporting Service
I have a serious problem that cannot be solved by googling around the keywords below: sharepoint, moss 2007, reporting service, ssrs 2008, rendering, internal server error, .... The error is; "An error occurred during client rendering. The remote server returned an error: (500) Internal Server Error. " Everything is O.K.; * When I render the report from the REPORTSERVER (http://localhost/ReportServer) * When the reports are scheduled to be sent by the reporting service (planned via MOSS 2007) But if I open (render) the RDL file from the sharepoint REPORTS LIBRARY interface, all of the reports fail with that internal error message above. It is weird also that parametrized reports are displayed without errors although the parameters are queried from a sql dataset. But I got the error when rendering the report after I've chosen a parameter and order "apply/report"... Possible causes how I met that error may be; After I have installed (then uninstalled) AJAX extensions After I have re-configured IIS Web Service Extensions list items Possible solution alternatives I've found; I've found a solution on MSDN replying a similar issue with an ideal cause of the error but an evreka answer but no solution suggestion from the author. What the guru says is; "The report is successful in reporting services, but SharePoint never gets and renders the report. You can check your wait times in RS and SharePoint(ASP). When we checked them RS was 9000 and SharePoint was 2000. When we increased the SharePoint, the report rendered." But how? See detail at http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/65f5db23-1a6a-47fc-8bf6-b90b9ce1fff0 I'll appreciate for the exact match to my trouble :(
July 10th, 2009 2:36pm

Hi Jurnalist, From your description, the error 500 Internal Server Error occurred while previewing the report in SharePoint Integrated mode. Based on our documents, the error could be caused by the anonymous access. If Anonymous access is enabled on the SharePoint Web Application Site, then we get above error while trying to browse the Report even if the integration of Reporting Services has been done correctly with SharePoint. To solve the issue, please ensure that Anonymous access is disabled on the SharePoint Web Application in Internet Information Server (IIS). If the solution above does not help, could you please help to post the logs of SQL Server Reporting Services and SharePoint. The logs will help us to solve the issue. We can get the logs from: SQL Server Reporting Services 2005: <Install Driver>:\Program Files\Microsoft SQL Server\MSSQL.<X>\Reporting Services\LogFiles SQL Server Reporting Services 2008: <Install Driver>:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\LogFiles SharePoint logs: < Install Driver>:\Program Files\Common Files\Microsoft Shared\web server extensions\12\LOGS For more information, please see: Requirements for Running Reporting Services in SharePoint Integrated Mode: http://technet.microsoft.com/en-us/library/bb283190.aspx Please feel free to ask, if you have any more questions. Thanks, Jin ChenJin Chen - MSFT
Free Windows Admin Tool Kit Click here and download it now
July 13th, 2009 7:21am

Hi journalist!!!, from sharepoint --> Central Administration --> authentication providers --> DISABLE Client Integration!!!! FINALLY WORKS!! Please ask, If you have any questions Thanks! David Giovanon
May 30th, 2011 11:05pm

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

Other recent topics Other recent topics