Configure SSRS for SharePoint Integration Mode SharePoint

SSRS has two modes.

1-Native mode: Build reports by hand and then look at them.

2-Integration mode: SharePoint Integration mode allows you to add Reporting Services content types to SharePoint, and then build and manage your reports from SharePoint.

Below are the steps:

Step-1. Click Start -> All Programs -> Microsoft SQL Server 2008 R2 -> Configuration Tools -> Reporting Services Configuration Manager.

Step-2. On pop-up window, click Connect.

Step-3. From the left-hand side of the window, click Web Service URL.

Step-4. Click the Advanced button.

Step-5. Click Add for the HTTP section.

Step-6. Select Host Header Name and enter

Step-7. Click OK.

Step-8. Highlight the “all assigned listener” item above it and click Remove.

Step-9. Click OK.

Step-10. Click Database on the left.

Step-11. Click the Change Database button.

Step-12. Select “Create a new report server database” and click Next.

Step-13. For “Connect to Database Server,” accept the defaults and click Next.

Step-14. From the Report Server Mode, select SharePoint Integrated Mode.

Step-15. Click Next.

Step-16. For Authentication Type, leave Service Credentials and click Next.

Step-17. From the Summary screen, click Next.

Step-18. Everything will be successful, and you can click Finish.

Step-19. All other settings should work as it is, so click Exit.


Leave a Reply

Please log in using one of these methods to post your comment: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s