Welcome to weblogs.com.pk Sign in | Join | Help

Sharepoint and SQL Server Reporting Services

SQL Server 2005 Reporting Services SP2 or later can be integrated with Sharepoint. Setting it up is bit tricky. http://msdn.microsoft.com/en-us/library/ee384252.aspx URL is must read to troubleshoot the issues. For me following worked

  • Ensure only Windows Integrated Authentication is checked on http://server/ReportServer
  • DisableLoopBackCheck using http://support.microsoft.com/kb/896861
  • Use Windows Authentication in SQL Server Reporting Services Integration option of Central Administration
  • Make sure your login is Central Administration’ Site Collection Administrator; activate the Reporting Feature from Site Collection Features of Central Administration
  • Using the same Web site’ IIS Pool for Report Server and Sharepoint site
  • Using the same login to run the Report Server’ Windows Service which is used for IIS Pool
  • Giving the Site Owner role to the same login; also making this login part of local Administrators group

While publishing from Visual Studio; use the following:

Target Data Source Folder: http://sharepoint-site/Reports/Documents/Data Sources
Target Report Folder: http://sharepoint-site/Reports/Documents/TheReports
Target Server Url: http://sharepoint-site/reports

I had Sharepoint Portal Server; sharepoint-site/reports is Report Centre url; and I wanted to deploy my reports into its Documents document library!

Published Saturday, January 02, 2010 1:02 AM by khurram

Comments

# re: Sharepoint and SQL Server Reporting Services

Saturday, January 02, 2010 1:07 AM by khurram

http://msdn.microsoft.com/en-us/library/bb677368(SQL.90).aspx discusses how to install these two on single box.

http://blogs.msdn.com/sharepoint/attachment/4194088.ashx is Installation/Configuration Guide for SharePoint Integration Mode

New Comments to this post are disabled