Integrating Sharepoint 2010 and SSRS 2008

SharePoint Integration

Markus Kolbeck
Markus' Blog
2 min readApr 9, 2013

--

Followed the steps described in Integrating Sharepoint 2010 and SQL Reporting Services 2008 in 6 easy steps.

One note: Make sure you run IE as Administrator (when navigating to SharePoint Central Administration locally on the SharePoint Server) in Step 4: SharePoint Integration Configuration — Reporting Services Integration.

Report Deployment (in VS2008)

Deployment URLs and Folders

Make sure you adjust the URLs correctly in the project’s properties.

SSRS1

Shared Data Source

If you are not using Kerberos, and you are conneting to a 3rd party Data Source (e.g. K2 SOURCECODE), you can only configure “Integrated Security” or “Do not use credentials”.

SSRS2

If you choose to set the Credentials to “Do not use credentials”, you must specify the Execution Account in the SSRS Configuration Manager.

See Configuring the Unattended Execution Account

Note: I would recommend using Kerberos authentication.

Additional Ajdustments

Disable debugging

I got the error similar to:

Message: Sys.ArgumentNullException: Value cannot be null.
Parameter name: panelsCreated[6]

FIX: “Sys.ArgumentNullException” error occurs when you open a drillthrough report in a Report Viewer Web part if you use the SharePoint Integrated mode in SQL Server 2008 R2 Reporting Services

#sharepoint

--

--