Tuesday, November 9, 2010

Configure Reporting Services with SharePoint 2010

This post is in continuation from this post, where we saw how to proceed with this install and configuration when we already have the DBEngine, Analysis Services, etc installed on a SQL Box except for the Reporting Services.
Here, I proceed from where we select the Reporting Services Configuration Manager from the Configuration Tools.
image
Start the Reporting Services Configuration Manager and find your server/instance.
image
Click connect and you will see the next screen:
image
Follow the screens depicted as below to complete the rest of configurations.
image
image
image
image
image
image
image
image
image
image
image
I skipped the Report Manager URL, Email Settings and Executive Account as it is not mandatory at this step.
image
Take the encryption key backup.
Scale-out Deployment was disabled.
Now go back to the Web Service URL and Click Apply.
image
Next, you need to configure the Central Admin.
Go to CA –> General Application Settings –> Reporting Services Integration
image
And that should be all.

Update: Dec 23, 2011
If you need to read more about some of the requirements for running SSRS in SharePoint Integrated mode, visit this MSDN article.

And this Technet details much about SSRS Integration in SP 2010.

No comments: