SharePoint 2010: Troubleshoot SQL Server Reporting Services (SSRS)
Installation and Upgrade
- Report Builder does not work after you upgrade from SQL Server 2008 SP1 to SQL Server 2008 R2
- SharePoint Central Administration page displays a failed status after upgrade
- You are not able to install the Reporting Services Add-in for Microsoft SharePoint
- Existing sites and subscriptions fail after you upgrade SharePoint products and convert to Claims Authentication
- Model item permissions need to be updated
- Reporting Services icons do not appear when integrated with SharePoint 2007
- You cannot see Reporting Services icons after you upgrade to SharePoint 2010
- SharePoint Central Administration Pages are blank
- [[articles:Error: Unsupported Reporting Services Functionality]]
Configuration and operations
- You are not able to grant database access in SharePoint Central Administration
- You cannot access your Web applications by using the server's IP address
- You cannot access your report server page after converting to Claims Authentication
Using SharePoint Integration
- (SSRS) You see an error message about insufficient permissions when run a report from a SharePoint Library
- You see an error message regarding ContainerTypeNotSupported when you view a report from a SharePoint document library
- You Receive an InvalidDataSourceCredentialSettingException When You Attempt to Test Connection on a SharePoint List Data Source
Report viewing and Reporting Services application pages
- You are not able to run reports following the creation of a new Web application
- Reporting Services-specific Help is not available from SharePoint Central Administration pages
- You see an access denied error message when trying to design a query based on a SharePoint list
- If you click Cancel while a report is loading, the Apply button in the parameters pane no longer works
- You see the error message “403 Forbidden response” when rendering a report with _vti_bin/ReportServer in the URL
Local and connected Mode
See Also
External Links
- Troubleshooting (Reporting Services)
- For additional troubleshooting recommendations, see the published white paper, Reporting Services SharePoint Integration Troubleshooting.
- Report Server Service Trace Log
- SharePoint Products technical information