Home / server / Questions / 336120
In Process
Tedd Hansen
Asked: 2011-12-01 00:15:52 +0800 CST

Multiple Reporting Services databases in one instance?

  • 772

Is it possible to have multiple Reporting Services databases in one MSSQL instance?

I have a MSSQL 2008 R2 with RS set to SharePoint Integrated Mode. This RS is in use and can't be changed. I do however need a RS in native mode for the TFS installation to be able to use it.

Am I required to set up a new instance of MSSQL?
Bonus question: If so, is that permitted under the MS licensing scheme or is it an additional cost?

sql-server ssrs

1 Answers

  1. For the bonus question sql server is licenced per CPU (or CALs), so there is no extra charge per instance.

    • 0