Setting up SSRS Availibilty groups on SQL 2016 Standard

Question

Setting up SSRS Availibilty groups on SQL 2016 Standard

mpoulter35

SSC-Addicted

Points: 403
More actions
October 23, 2017 at 6:07 am

#325901

Is it possible to setup SSRS reports for always on availability groups in SQL 2016b standard? I have set it up put get following error.
The feature "Scale out deployment is not supported in this edition of reporting services"
Any help with this would be greatly appreciated

Ant-Green SSC Guru Points: 112965 More actions · Answer 1

SSRS Standard only supports 1 SSRS server per SSRS database, if you want to do scale out deployments using the native SQL ways you need to install Enterprise.

That being said there are ways around it NLB, multiple databases etc, do a search for "SQL Standard SSRS Scale Out" and you should come up with some good options.