wanted to ask if my design is on the right track for installing SSRS.
Currently i have 2 nodes in an Always ON AG (2017 Enterprise Edition).
There is an application update coming up that will require the use of SSRS. No users will access the SSRS portals and the application will display the reports.
If the SSRS server is not available the application will work unless you go to the section that shows the reports, but everything else will work.
My question is, should I stand up SSRS on the two SQL Nodes in a scale out deployment and have them sitting behind my Net Scaler load balancer?
Should I just setup a 3rd box and get SSRS installed on a separate box to make the config simple like a 3rd node (Sync or Async) with manual failover to host the ssrs server and its databases?
Just trying to see what is the best angle to go here to give me the lease amount of headaches in the future.
I think the scale out deployment is a good way to go due to not having yet another server to manage, but i then need to depend on the net scaler admin to make sure they are doing their jobs in the setup, but i would like to get some feedback from you guys.
Thanks,
Best Answer
You have to take in count that a 3rd box with SSRS counts more license. In that case you have to place the SSRS databases on the alwayson cluster and the SSRS website on the 3rd box. You will not have HA solution for it and you will suffer downtime for server maintenance.
Otherways, if you choose the scale out deployment on the alwayson cluster with a net balancer in front of it you will have redundancy and no increase in license costs. But you need a new component in the architecture, a network balancer. You can't enable microsoft NLB on the clusters' nodes because it is not compatible with the cluster itself.