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.

Categories: SharePoint 2013, sharepoint2010, SSRS

Tags: , , ,