Symptom
Reporting Services Error
--------------------------------------------------------------------------------
Report Server has encountered a SharePoint error. (rsSharePointError) Get Online Help
Object reference not set to an instance of an object.
Resolution
- Launch the SQL Management Studio hosting the Sharepoint databases.
- View the mapped permissions for SSRS account configured in Reporting Services (i.e. DOMAIN\SYS-SSRS-ENV)
- Provide dbowner access for this account to the web application that the SSP and MySites is configured on. If you have created separate web applications for each SSP and MySites ensure dbowner is configured for both