Hi Jey, There are multiple underlying causes to this error, and the one you encounter could be different from the ones listed here. This can be caused when there is a SharePoint content database to which the Reporting Services instance does not have access. This can also be caused by an orphaned SharePoint site collection. This is a site collection that, when clicked on, has all of its properties dimmed or empty. If the error is a database access issue, follow these steps to resolve it: On the Central Administration home page, click Application Management, click Reporting Services, and then click Grant Database Access. Enter the Reporting Services machine and instance name, and then click OK. Enter the credentials to connect to the Reporting Services machine, and then click OK. This should grant the Reporting Services service accounts the required access to the SharePoint content databases. Try to browse to http://<Server>/ReportServer. If the error is an orphaned site collection, you can try the following. Caution: This solution is unverified, so you should back up the SharePoint content databases in question before you run the final step to repair the issue. Open a command prompt on the SharePoint server. Type cd %commonprogramfiles%\Microsoft Shared\web server extensions\12\BIN Type stsadm -o databaserepair -url http://<SharePointSiteURL> -databasename <Name of the SharePoint Content Database for the site> If you run the previous command and receive output regarding orphaned sites, run the following command to try and repair it: stsadm -o databaserepair -url http://<SharePointSiteURL> -databasename <Name of the SharePoint Content Database for the site> -deletecorruption Repeat steps 3 and 4 for every SharePoint site. Challen Fu [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Hi, I do the below problem in the SSRS 2008 Report Server which runs in SharePoint Integrated Mode. The Report Server URL http://<machine_name>/reportserver is not works and display the error "Report Server has encountered a SharePoint error. (rsSharePointError)" The error log has the below information. e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.SharePointException: Report Server has encountered a SharePoint error. ---> System.NullReferenceException: Object reference not set to an instance of an object. i INFO: The permissions granted to user 'XXXX' are insufficient for performing this operation. Other than this everything works well in this report server, example scheduled reports, Run reports in Report Builder, etc. Please help me to understand the problem and significance of the report server URL? Thanks, Jey