SQL Server Reporting Services(2008) reports and SharePoint integration

Issue:
The reports were deployed to the Document Library but when we tried to access them the following error kept popping up
• An error has occurred during report processing. (rsProcessingAborted) Get Online Help
Cannot create a connection to data source ‘data_source1’. (rsErrorOpeningConnection) Get Online Help
Internal 500 error. Database access denied.

Fix:
After some intense research we discovered that the problem was not RS as such, but the IIS setup hosting it.
IIS was handling the app pool in an aggravating way.
The fix was to set its properties so that under Performance, the idle timeout was disabled. We could access the reports from http://MOSSServer/SharedDocument folder afterward.
However, we could not add the reports as web parts.
Research revealed that the web part “ReportViewer.dwp“ had to be manually added to the web part collection.
ReportViewer.dwp can be found in the following folder
“C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\FEATURES\ReportServer”
The steps involved in adding are as follows,
My Site -> Site Actions -> Site Settings -> Galleries -> Web Parts -> Upload and browse to the ReportViewer.dwp file and add it.
On refreshing we can see the added web part named, SQL Server Reporting Services Report Viewer.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s