SSRS Installation on Single and Multiple Servers

Please find the below steps for SSRS installation


Single Server Farm Installation
1.       Install SQL Server (Select Reporting Service - SharePoint, Reporting Services add-in for SharePoint Products)
2.       Ensure SharePoint-native mode is not selected
3.       Install SharePoint server
4.       Run Install-SPRSService
5.       Run Install-SPRSServiceProxy
6.       Ensure SQL server Reporting Service is started in “Manage Services on Server”
7.       Create SQL Server Reporting Service application from “Manage Service Applications)
1 SQL Server
1 SharePoint Server (APP + WFE)
SQL Server :
1.       Install SQL Server (Select Reporting Service – SharePoint, Reporting Services add-in for SharePoint Products)
2.       Ensure SharePoint-native mode is not selected
SharePoint Server :
1.       Install SharePoint Server
2.       Using SQL setup media that is used in the SQL server, install Reporting Service – SharePoint, Reporting Services add-in for SharePoint Products) only – only two checkbox has to be selected
3.       DO NOT INSTALL DATBASE ENGINE
4.       Run Install-SPRSService
5.       Run Install-SPRSServiceProxy
6.       Ensure SQL server Reporting Service is started in “Manage Services on Server”
7.       Create SQL Server Reporting Service application from “Manage Service Applications)

Multiple SQL Server + Multiple SharePoint Server
SQL Server Role – Irrespective of no of servers (only if it is clustered)
1.       Install SQL Server (Select Reporting Service – SharePoint, Reporting Services add-in for SharePoint Products)
2.       Ensure SharePoint-native mode is not selected
SharePoint Application Server Role
1.       Install SharePoint Server with Application role
2.       Using SQL setup media that is used in the SQL server, install Reporting Service – SharePoint, Reporting Services add-in for SharePoint Products) only – only two checkbox has to be selected
3.       DO NOT INSTALL DATBASE ENGINE
4.       Till step 3 do it in all SharePoint App server, and hold for a while and continue the steps in WFE Servers
5.       Run Install-SPRSService
6.       Run Install-SPRSServiceProxy
7.       Ensure SQL server Reporting Service is started in “Manage Services on Server”
8.       Create SQL Server Reporting Service application from “Manage Service Applications)
SharePoint WFE server Role
1.       Install SharePoint Server with WFE Role
2.       Install only the Reporting Services add-in for SharePoint Products only
3.       Continue with STEP 5 in all SharePoint app servers

Comments

Popular posts from this blog

Using External Content Types with Stored Procedures with Input Parameters

NAV 2009 Issues in Role Tailored Client