SSRS Scale Out with Standard Edition Containers and Instances

Question

SSRS Scale Out with Standard Edition Containers and Instances

pauls 72822

Ten Centuries

Points: 1049
More actions
January 28, 2019 at 9:33 pm

#416656

Comments posted to this topic are about the item SSRS Scale Out with Standard Edition Containers and Instances

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

peter.row SSCarpal Tunnel Points: 4319 More actions · Answer 1

I wonder if WinDock came up with this to avoid MS disastrous decision to make SSRS single instance per machine only as of SQL Server 2016 and above?
Also wonder how this copes with custom authentication.

pauls 72822 Ten Centuries Points: 1049 More actions · Answer 2

Yes, multi-instance is available for SQL Server 2016 SSRS, and work is progressing on SQL 2017 support. Drop us a note at support@windocks.com to let us know about your custom authentication needs. We would be interested, and would be in line with our plans.

peter.row SSCarpal Tunnel Points: 4319 More actions · Answer 3

pauls 72822 - Tuesday, January 29, 2019 4:18 AM
Yes, multi-instance is available for SQL Server 2016 SSRS, and work is progressing on SQL 2017 support. Drop us a note at support@windocks.com to let us know about your custom authentication needs. We would be interested, and would be in line with our plans.

My comment was a unsubtle attack on Microsoft SSRS in SQL 2014 and earlier could be installed multiple times on the same server machine but with SSRS in 2016 and 2017 the installer prevents you from installing it more than once on a machine thus why containers work. It's just frustrating MS are forcing everyone down this route.

pauls 72822 Ten Centuries Points: 1049 More actions · Answer 4

Multi-instance use is included in the SQL Server licenses, and widely relied on for the past decade. Asking Microsoft why this is being curtailed is a fair and reasonable question.

pauls 72822 Ten Centuries Points: 1049 More actions · Answer 5

If you're interested in multi-instance support for SQL 2016 SSRS, or SQL 2017 SSRS, please email support@windocks.com. We're interested to build a list of people interested in early access, for feedback/input to our plans.

rackerland Old Hand Points: 359 More actions · Answer 6

Very interesting approach and a well written article! I've been looking for scalable and redundant SSRS farm alternatives using Standard Edition to save on licensing costs vs. Enterprise Edition.
What would be the solution for Report Subscriptions in this scenario? Since the Subscription details are written to the local ReportServer DB, there would be unique Subscriptions in each container, so I wouldn't think the image would be reusable in that case.
Thanks again for the great write-up!

pauls 72822 Ten Centuries Points: 1049 More actions · Answer 7

Good point, one of the nice aspects of the design is that it easily scales to support varied images as well.