SSRS Scale Out with Standard Edition Containers and Instances

  • pauls 72822

    Ten Centuries

    Points: 1041

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

  • peter.row

    SSCarpal Tunnel

    Points: 4296

    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: 1041

    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: 4296

    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: 1041

    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: 1041

    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: 329

    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: 1041

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

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

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