ERROR in reporting services integration : Object reference not set to an instance of an object
Hi,
I am trying to setup Reporting services for my Sharepoint environment and I am having an error 'object reference not set to an instance of an object' when I select 'Reporting Sevices Integration' under 'General Application Settings'.
I have a server with SP2010 and i manually instatlled SQL 2008 R2 Reporting services Add later. The Report Server Central Features and Report Server Integration Feature are active.
I have a second server that is the sp database server and has report server running is sharepoint integrated mode under spAdmin credentials.
Here is the log for the report service add-in install:
2011-01-28 14:16:31: User: setupadmin
2011-01-28 14:16:31: Installing Report Server feature.
2011-01-28 14:16:33: Calling copyappbincontents command.
2011-01-28 14:16:50: SharePoint Products Configuration Wizard version 14.0.4762.1000. Copyright (C) Microsoft Corporation 2010. All rights reserved.
Performing configuration task 1 of 3
Initializing SharePoint Products configuration...
Successfully initialized the SharePoint Products configuration.
Performing configuration task 2 of 3
Installing the application content files...
Installing the SharePoint Central Administration Web Application content files...
Installing the SharePoint Web Application content files...
Successfully installed the application content files.
Performing configuration task 3 of 3
Finalizing the SharePoint Products configuration...
Successfully completed the SharePoint Products configuration.
Total number of configuration settings run: 3
Total number of successful configuration settings: 3
Total number of unsuccessful configuration settings: 0
Successfully stopped the configuration of SharePoint Products.
Configuration of the SharePoint Products has succeeded.
2011-01-28 14:16:50:
2011-01-28 14:16:50: copyappbincontents command completed successfully.
2011-01-28 14:16:50: RS SharePoint Add-in already installed
Following is a snippet of the sharepoint log:
Timestamp
Process TID
Area
Category
EventID Level Message Correlation
02/08/2011 12:16:24.88 w3wp.exe (0x18E4)
0x13CC SharePoint Foundation
Logging Correlation Data xmnv Medium
Name=Request (GET:http://ev-tst-sp01:40721/_admin/ReportServer/ReportServerSiteSettings.aspx) d35cf5f8-98f7-40b7-9d88-627e952a9818
02/08/2011 12:16:24.88 w3wp.exe (0x18E4)
0x13CC SharePoint Foundation
Logging Correlation Data xmnv Medium
Site=/ d35cf5f8-98f7-40b7-9d88-627e952a9818
I think it means that the login permission is not correct, but i have the report server running on the sharepoint database server with setupadmin service account. The setupadmin is a sharepoint administrative account and it should work.
I also noticed that i can not point to the report manager url with setupadmin access when i am in the database server that is running the report server. Following is the setup of the reporting server:
https://picasaweb.google.com/Asif.S.Chowdhury/UntitledAlbum#5571389849480405138
What am i missing? :(
-Asif
February 12th, 2011 12:14pm