June 4, 2008 at 8:28 am
If I have a SQL Server 2005 Enterprise license, can a web farm installation for reporting services use a share database that is SQL Server 2005 Standard?
The reason that I ask is because our production environment is SQL 2005 Enterprise, and I want to create a reporting environment where the reporting services are installed on multiple servers, and point to a reporting database. I am trying to avoid spending an extra 80K for an enterprise license for my reporting servers.
June 5, 2008 at 6:25 am
As I read it, in Standard Edition it is not possible to have multiple SSRS instances use the same reporting database.
see for intance , that also points out other possible solutions (e.g.: use multiple "stand alone" SSRS instances, and spread either the reports or the users over the instances).
Peter Rijs
BI Consultant, The Netherlands
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply