Welcome to MSDN Blogs Sign in | Join | Help

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)
Published Friday, March 03, 2006 1:44 PM by russch

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

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

Monday, November 13, 2006 10:43 PM by kdoyle

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?

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

Thursday, November 16, 2006 8:50 AM by russch

If you execute the query "select @@version" in SQL Server Management Studio against your server, you'll get something like this (note my version is odd because I'm running a beta of SP2)

Microsoft SQL Server 2005 - 9.00.3027.00 (Intel X86)

       Oct 27 2006 15:59:00

       Copyright (c) 1988-2005 Microsoft Corporation

       Developer Edition on Windows NT 6.0 (Build 5600: )

Note the "Developer Edition" Part.....

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

Thursday, January 18, 2007 11:40 AM by Jim

How do you know which version of SQL Reporting Services you have installed?

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

Monday, January 22, 2007 1:46 PM by russch

Check the ReportServerService log file in C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles. You'll see something like this:

ReportingServicesService!resourceutilities!4!1/22/2007-13:44:00:: i INFO: Reporting Services starting SKU: Enterprise

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

Friday, March 09, 2007 5:17 AM by MagnusJ

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...

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

Monday, May 07, 2007 6:35 PM by Chinmay

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

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

Tuesday, June 26, 2007 7:58 PM by Israel

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.

PS

I´m new in this databases stuffs.

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

Monday, January 14, 2008 6:23 PM by Thomas

Here's the query that will tell you what you're running...

SELECT  SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

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

Thursday, June 19, 2008 5:51 PM by Sad DBA

It's unnecessary things like this that make me cry myself to sleep at night.  Why do you hate us, Microsoft?

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

Monday, March 16, 2009 4:56 PM by Aaron

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?

Version

------------------

9.00.4035.00 SP3 Standard Edition

Log File

------------------

ReportingServicesService!library!8!3/16/2009-15:16:55:: e ERROR: restricted SKUs: Workgroup Express Developer Enterprise Standard  - actual SKU Standard

ReportingServicesService!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.

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

Tuesday, March 17, 2009 11:54 AM by Marvin.

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

# Russell Christopher s Semi Useful BI Musings Using Scale Out | fix my credit

Tuesday, June 16, 2009 10:43 PM by Russell Christopher s Semi Useful BI Musings Using Scale Out | fix my credit

PingBack from http://fixmycrediteasily.info/story.php?id=7912

Leave a Comment

(required) 
required 
(required) 

  
Enter Code Here: Required
 
Page view tracker