Поделиться через

Using "Scale-Out" deployments In SQL Server Reporting Services 2005

  • Статья

Today I really played around with scale out deployments in 2005 (known as "reporting farms" in earlier versions) for the first time since I worked with them in 2000, and found an interesting behavior:

I wanted to point my 2005 Enterprise Edition at a reportserver database sitting on 2005 Developer Edition. I figured this would work, because books online says:

Requirements for a scale-out deployment include the following:

  • The Reporting Services edition must be Enterprise, Developer, or Evaluation. Standard edition does not support a scale-out deployment.

Well, it's not quite that simple. It turns out that while Enterprise and Developer can be part of the same Scale-out deployment, you can only join a Developer Edition web service TO an Enterprise reportserver database. If you try and do what I did, you 'll get this error message:

The feature: "Using other editions of SQL Server for report data sources and/or the report server database" is not supported in this edition of Reporting Services

Many Thanks to Brad Syputa for helping me out with this!

...and many thanks to Heidi Steen who just sent me some additional information which will be in a future update of books online!

For this edition of SQL Server 2005 Reporting Services

Use this edition of the Database Engine instance to host the database

SQL Server 2005 Express Edition with Advanced Services

SQL Server 2005 Express Edition with Advanced Services (local only).

Workgroup Edition

Workgroup Edition (local only)

Evaluation Edition

Standard, Evaluation, Enterprise Editions (local or remote)

Developer Edition

Standard, Developer, Enterprise Editions (local or remote)

Standard Edition

Standard, Enterprise Editions (local or remote)

Enterprise Edition

Standard, Enterprise Editions (local or remote)

Comments

  • Anonymous
    November 13, 2006
    So how do you find out what edition of the database engine instance you've got installed?  I'm a developer who some time ago either installed the developer or standard edition, I no longer remember which.  I'm now trying to add Reporting Services, and I tried the std edition.  All the version numbers are showing up as 9.00.1399.06, so I'd think they would be compatible but I get the "using other editions is not supported" error and I can't get past the database connection page.  Uninstalling RS seems to be an issue as well-- I tried control panel->add/remove progs->ms sql server 2005->change->reporting services and set it to "will not be available" but it has no effect.  Do I have to reinstall all of SQL Server 2005 just to add RS at this point because I chose to install the wrong one?
  • Anonymous
    November 16, 2006
    The comment has been removed
  • Anonymous
    January 18, 2007
    How do you know which version of SQL Reporting Services you have installed?
  • Anonymous
    January 22, 2007
    Check the ReportServerService log file in C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFiles. You'll see something like this:ReportingServicesService!resourceutilities!4!1/22/2007-13:44:00:: i INFO: Reporting Services starting SKU: Enterprise
  • Anonymous
    March 08, 2007
    Well, this is really a bummer.Today I just experienced this error message, trying to integrate my Reporting Services db (Developer edition) with the Sharepoint Services DB (MOSS 2007, Express edition).I will guess that the only solution is to upgrade the Express to Development...
  • Anonymous
    May 07, 2007
    I had SQL Express installed earlier. But I uninstalled it followed by installing a  Enterprise Edition SQL Server 2005. But the report service still feels that the database is express and not enterprise.Any ideas on getting the setup to point to the enterprise database. Appears the Express uninstall did not do a clean uninstall
  • Anonymous
    June 26, 2007
    I´m trying to run some reports that have been already created in Reporting Services 2005 in Reporting Servicies 2000, but I get the error "The feature: "Using other editions of SQL Server for report data sources and/or the report server database" is not supported in this edition of Reporting Services. (rsOperationNotSupported)" does anyone Knows how can I fix this problem.PSI´m new in this databases stuffs.
  • Anonymous
    January 14, 2008
    Here's the query that will tell you what you're running...SELECT  SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
  • Anonymous
    June 19, 2008
    It's unnecessary things like this that make me cry myself to sleep at night.  Why do you hate us, Microsoft?
  • Anonymous
    March 16, 2009
    I know this is a very old thread but I'm receiving this error on standard edition.  SQL Report Services was not installed so I went to Add/Remove Programs | Change | Etc. to install Reporting Services.According to the table above I should be able to use SSRS.  Any thoughts?Version9.00.4035.00 SP3 Standard EditionLog FileReportingServicesService!library!8!3/16/2009-15:16:55:: e ERROR: restricted SKUs: Workgroup Express Developer Enterprise Standard  - actual SKU StandardReportingServicesService!library!8!3/16/2009-15:16:55:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedException: The feature: "The Database Engine instance you selected is not valid for this edition of Reporting Services. The Database Engine does not meet edition requirements for report data sources or the report server database. " is not supported in this edition of Reporting Services., ;Info: Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedException: The feature: "The Database Engine instance you selected is not valid for this edition of Reporting Services. The Database Engine does not meet edition requirements for report data sources or the report server database. " is not supported in this edition of Reporting Services.
  • Anonymous
    March 17, 2009
    I had this problem on SQL Standard 2005 too.  I just notice that the backup i tried to mount came from SQL Standard with Service Pack 1, and my new Reporting Service Instance has Service Pack 2.  I´ll apply Service Pack 2 to my old instance and repeat the procedure.I hopy it works
  • Anonymous
    June 16, 2009
    PingBack from http://fixmycrediteasily.info/story.php?id=7912