Saturday, October 3, 2009

Report Server has encountered a SharePoint error. (rsSharePointError) Get Online Help Object reference not set to an instance of an object.

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

2 comments:

  1. Not sure i understand this. SYS-SSRS-ENV does not exist. Does this account need to be created as a domain account?

    ReplyDelete
  2. SYS-SSRS-ENV is an example of a system service account. Where possible, it is best practise to use domain user (service) accounts instead of local ones.

    ReplyDelete