[Script of Apr. 3] Complete the Reporting Services with SharePoint Integration configuration

  • Article

Script Download: IntegrateSSRSToSharePoint.zip
https://gallery.technet.microsoft.com/scriptcenter/Complete-the-Reporting-0971816b

This Windows PowerShell script achieves the same function as we to complete configure the Reporting Services integrate to SharePoint in SharePoint Central Administration. This script applies to SQL Server Reporting Services 2008 R2 or SQL Server Reporting Services 2008 integrate to SharePoint 2010.

When we need to configure SQL Server Reporting Services in SharePoint integrated mode, after installed and configured both SQL Server Reporting Services side and SharePoint side, in traditional way, we need to bind the report server URL and set authentication type in the SharePoint Central Administration.  Actually, we can also easily set these steps by using script. It is suitable for bellowing two conditions:

  • Never integrated any SQL Server Reporting Services to this SharePoint.
  • Had ever integrated SQL Server Reporting Services to this SharePoint, need to integrate one new SQL Server Reporting Services to this SharePoint. 
image image
image

You can find more All-In-One Script Framework script samples at https://aka.ms/onescriptingallery