Setting up
Reporting Services for a SharePoint 2010 in integrated mode can be done in less
than 30 minutes if you have the infrastructure ready. However there are a few
things to take care of if we are in a SharePoint farm environment with
different servers handling different roles.
To get
Reporting Services to work in SharePoint Integrated mode requires SharePoint
object model. Either we install SharePoint object model on our database server
running Reporting Service or install SQL Server Reporting Service on a
SharePoint application server.
Here are a
few things to take care of:
1. Use a
domain account in the Reporting Services Configuration Manager
2. In the Reporting
Services Configuration Manager wizard, click on Apply in different screens
before navigating away.
3. Reporting
Services Add-in is required on SharePoint Servers; it is part of the SharePoint
2010 pre-requisite installer. It can also be downloaded and installed separately
on SharePoint Servers.
To get this
working we have configuration to do in the SharePoint Central Administration
website and on the Reporting Services Configuration Manager.
Here are
the steps:
1. Install
Reporting Service on a SharePoint application server or install SharePoint web role on
the SQL Server with Reporting Service enabled.
2. Open
Reporting Services Configuration Manager – Service Account – provide a domain
account to run Report Server Service. Click Apply.
3. In the
section Web Service URL, provide a name for virtual directory in IIS for Report
Server web service. Other settings in this page can be left alone unless you
need the website to use SSL. Click Apply and if you see an hyperlink under the
heading Report Server Web Service URLs, the configuration is proper.
4. In the
next screen named Database, create a new Report Server database and make sure
to select SharePoint Integrated Mode. Once required information is entered and
connection is tested, click Apply.
5. Report
Manager URL is not relevant for an SharePoint integrated environment, click
Apply and navigate to next screen.
If we
click on the report manager URL we would receive an error at this point because
we don't access reports through report manager in SharePoint integrated mode,
we access through SharePoint.
We are
almost done with the configuration here; make sure you backup encryption keys
before closing the configuration manager.
6. Open Internet Explorer
as administrator and navigate to Central Administration – General Application
Settings – Reporting Services and provide the web service url we found in the
web service url screen in Reporting Services Configuration Manager.
7. Under
Authentication Mode, select Windows Authentication if the web application to
host reports is using classic authentication, if its using claims then select
Trusted Account.
If the web
application is using claims authentication it would be using Trusted Authentication
irrespective of what we select here.
8. Provide
credentials of a user who has administrative privilege on the server hosting
Report Server. Also we have an option to activate the Reporting Service feature
on all existing site collections or on specific ones. Click Ok.
9. To test
the configuration navigate to Report Server url.
That
concludes the configuration and now we can start deploying reports using tools
like Microsoft Business Intelligence Development Studio (BIDS) or directly
using Report Builder.
Happy reporting!
Happy reporting!
Comments