SQL Server Reporting Services Integration with SharePoint

Written By: Abin Jaik Antony -- 10/20/2010 -- join -- contribute -- (4744) comments -- printer friendly version

Rating: Rate --

Categories: Configurations, Integration with other products , MOSS 2007, WSS3

< Prev - 1 | 2 | 3 | 4 | - Next > | Become a paid author

Windows Service Identity

Windows Service Identity manages the security account under which the Report Server service runs. By default, this service runs under the NT Authority\Network Service account. You might want to use a domain account instead of a built-in account.

Click for Larger Image

Web Service Identity Configuration

The Web Service Identity Configuration is set by default with the ASPNET Account. But we can configure this account by setting the identity account of the Application pool on the IIS.

Click for Larger Image

Next is setting up the database for the Report Server. Here we need to set a database for storing report snapshots and rdl files (secondary storage for SharePoint Integrated mode). Also, set the Server Mode to SharePoint Integrated Mode.

Click for Larger Image

After applying this step, all the required sections will be configured as shown in the above step.

After the configuration of reporting services in SharePoint Integrated Mode, we need to update the Reporting Services Integration in SharePoint Central Administration. On the Application management tab of Central Admin we can find the “Reporting Services” section. Under this section go to the “Manage integration settings” and give the Report Server URL .

Click for Larger Image

< Prev - 1 | 2 | 3 | 4 | - Next >

Learn more about SharePoint

Sponsor Information

Copyright (c) 2010-2017 Edgewood Solutions, LLC All rights reserved
privacy | disclaimer | copyright | advertise | contribute | feedback | about
Some names and products listed are the registered trademarks of their respective owners. |