Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

Restore multiple instance support for Reporting services in SQL 2017

Please restore the multiple instance support per server for Reporting Services 2017. SQL Server reporting Services has supported multiple instances on one server in versions SQL 2000 thru 2016 and it was removed by design with the release of SQL 2017. This was a bad move as it will force my company to deploy 6X as many servers to deploy what is a lightweight application server.

I'm not sure if this has anything to do with the PowerBI integration with SSRS, but it also suffers from this bad decision as well.

Best Regards,
James Fuller
James.fuller@amwins.com

151 votes
Sign in
(thinking…)
Password icon
Signed in as (Sign out)

We’ll send you updates on this idea

James Fuller shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

27 comments

Sign in
(thinking…)
Password icon
Signed in as (Sign out)
Submitting...
  • Jeff commented  ·   ·  Flag as inappropriate

    This will cause my company to consider a different reporting tool. We are doing a new system implementation starting from scratch and we picked SQL Server 2017 because it was the latest and greatest, but this has stopped us in our tracks.

  • Anonymous commented  ·   ·  Flag as inappropriate

    For us this is show-stopper for upgrade to SQL Server 2017. Our customers use SSRS named instances for separation of projects and for separation of environments (TEST, PROD, ...).

  • WLPLaura commented  ·   ·  Flag as inappropriate

    We use multiple instances of SSRS on the same server to isolate our test from production and for applications that require a specific version/patch level of SSRS.

  • Peter Row commented  ·   ·  Flag as inappropriate

    You chucked us under a bus when you change the way things work when implementing a custom security DLL if we need non-Windows auth. Now I come to investigate that problem and find you've pulled this stunt, unbelievable!!!!!!!!!

    Add it back now, no please, just ******** do! So angry right now.

  • Anonymous commented  ·   ·  Flag as inappropriate

    Please add this back in. We run many instances of SSRS 2016 on one server in a test environment. I really don't want to create a VM for each instance especially with as light of load as ssrs has during testing.

2 Next →

Feedback and Knowledge Base