How to plan sharepoint 2016 topology for ssrs sharepoint int

Sashank Kamuju

Hi ALL

Iam having a query regarding ssrs setup for below SharePoint 2016 farm

Total 6 servers are there in Test Farm
++++++++++++++++++++++++++++++++
2 servers with Application with search role
2servers with WFE with Distribution role
1 server sql DB
1 server SSRS

I see MS suggested that SSRS should be installed only on custom role server. So i will make/convert one of the WFE server to custom role and install Reporting Services – SharePoint / Reporting Services Add-in for SharePoint in that server.

Now the farm looks like this :-
2 servers with Application with search role
1servers with WFE with Distribution role
1 server With Custom
1 server sql DB
1 server SSRS

My query here is

1.Do i have to install that 2 components on any other servers in the above?
2.Does Custom role server will act as WFE server
3.What is purpose of having dedicated SSRS server
4.Diference between SSRS integrate mode and Native mode

Could you please suggest me the right topology!

Thank in advance
K.Sashank

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nanddeep Nachan8y ago
Yes, after installing 2 components
0
Sashank Kamuju8y ago
After 2 components installed? when to run sp wizard .....not getting plz
0
Nanddeep Nachan8y ago
Have you run the SharePoint Product Configuration wizard?
0
Sashank Kamuju8y ago
Tq nandeep....for your inputs i have settuped it!
but having one query
Current farm
+++++++++++++++++++
•2 servers with Application with search role
•1servers with WFE with Distribution role
•1 server With Custom

On custom server i have installed "Reporting service -sharepoint" and "Reporting service add-in for sharepoint" components ,
On wfe server i have installed "Reporting service add in for sharepoint"
The Installation was successfull ,but unable to see service application (ssrs)

But when i ran get-spserverinstance -server name "custom####" ,the service was showing as on-line but iam unable to see under

SharePoint 2016 Central Administration -> “Application Management” -> “Manage Services on Server” page

SharePoint 2016 Central Administration -> “Application Management” -> “Manage Service Applications” ->”New” menu

Do i have to install these 2 components on where CA (any one of the app server ) is running too ,to get affected ?
0
Nanddeep Nachan8y ago
Also, please read through an article here.
https://whitepages.unlimitedviz.com/2016/03/configuring-ssrs-2016-integrated-mode-sharepoint-2016/
0
Nanddeep Nachan8y ago
1.Do i have to install that 2 components on any other servers in the above?
Install SSRS componentes only on Custom role servers.

2.Does Custom role server will act as WFE server
I think YES - can be, because Custom Server Role include the below services
Distributed Cache
Microsoft SharePoint Foundation Administration
Microsoft SharePoint Foundation Timer
Microsoft SharePoint Foundation Web Application
These default services are auto-provisioned by default in Custom Server Role.

3.What is purpose of having dedicated SSRS server
SSRS does not support any other role than the Custom role. If your server is not running the Custom role, installation will succeed, but SSRS will be shut down by the roles engine during the next maintenance window.

4.Diference between SSRS integrate mode and Native mode
In native mode SSRS has it's own ReportServer web application. Report .rdl files are uploaded to this.
In integrated mode, the rdl files are uploaded to a SharePoint document library and are managed via SharePoint.

Hope this helps.
0