SQL SP2 Versions

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dan - 22 Mar 2008 16:30 GMT

I have 2 servers taht I have applied SQL 2005 SP2 on, but now they are
reporting different versions. What is the difference between
9.0.3054
and
9.0.3042?

I am having problems restoring my Report Server db from the machine with
3054 onto the one with 3042 and I think the problem is related. I am getting
the error:

The feature: "Scale-out deployment" is not supported in this edition of
Reporting Services. (rsOperationNotSupported) (rsRPCError)

Reply to this Message

Aaron Bertrand [SQL Server MVP] - 22 Mar 2008 17:24 GMT

3042 is the original SP2 release I believe. 3054 fixed some maintenance
plan issues.

http://support.microsoft.com/kb/934458
http://blogs.msdn.com/psssql/archive/2007/04/06/post-sql-server-2005-service-pac
k-2-sp2-fixes-explained.aspx

Have you considered upgrading both/all instances to 3054?

>I have 2 servers taht I have applied SQL 2005 SP2 on, but now they are
> reporting different versions. What is the difference between
[quoted text clipped - 9 lines]
> The feature: "Scale-out deployment" is not supported in this edition of
> Reporting Services. (rsOperationNotSupported) (rsRPCError)

Reply to this Message

TheSQLGuru - 23 Mar 2008 17:42 GMT

You may also want to review the list of fixes in the now six Cumulative
Update packages to see if you want to go ahead and upgrade to one of those.
IIRC, CU4 is the highest one you can get publicly (i.e. without contacting
MS for it).

Signature

Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net

> 3042 is the original SP2 release I believe. 3054 fixed some maintenance
> plan issues.
[quoted text clipped - 17 lines]
>> The feature: "Scale-out deployment" is not supported in this edition of
>> Reporting Services. (rsOperationNotSupported) (rsRPCError)

Reply to this Message

Aaron Bertrand [SQL Server MVP] - 24 Mar 2008 02:27 GMT

> You may also want to review the list of fixes in the now six Cumulative
> Update packages to see if you want to go ahead and upgrade to one of
> those. IIRC, CU4 is the highest one you can get publicly (i.e. without
> contacting MS for it).

CU5 and CU6 kind of require you to contact MS. I get hotfixes and CUs
through another avenue, but allegedly, you hit the support link on the page,
submit an e-mail address, and get a download link back (Neil and Geoff I
think (maybe just on or the other) discovered that you have to be very
specific about which hotfix you want, and for which platform). Unlike some
previous hotfixes, these two at least do not seem to require any actual
face/phone time with a real live support person.

Reply to this Message

Geoff N. Hiten - 24 Mar 2008 18:26 GMT

That was me.

When you request a hotfix, specify the version you are on, not the version
you want. These requests are handled in a semi-automated fashion. Most seem
to just skim the note and click to send an auto-pasted reply.

If you want the fix for mulitple platforms, submit separate requests for
each one.

Signature

Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP

>> You may also want to review the list of fixes in the now six Cumulative
>> Update packages to see if you want to go ahead and upgrade to one of
[quoted text clipped - 8 lines]
> Unlike some previous hotfixes, these two at least do not seem to require
> any actual face/phone time with a real live support person.

Reply to this Message

Charles Wang[MSFT] - 24 Mar 2008 04:57 GMT

Hi,
I believe that Aaron has provided you good suggestions for explaining the
version number. However from the error message, I think that this issue is
not related to SQL Server 2005 version number but SQL Server 2005 Edition
you used.

Please run SELECT @@VERSION to check if your SQL Server 2005 is Enterprise
Edition or Developer Edition. SQL Server 2005 Standard Edition does not
support scale-out deployment for report server.
Please refer to:
Configuring a Report Server Scale-Out Deployment
http://msdn2.microsoft.com/en-us/library/ms156453.aspx

Hope this helps.

Best regards,
Charles Wang
Microsoft Online Community Support
===========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@microsoft.com.
===========================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
============================================================

Signature

This posting is provided "AS IS" with no warranties, and confers no rights.

=========================================================

Reply to this Message

Dan - 25 Mar 2008 13:58 GMT

Here is the output from @@Version on my 2 servers. Neither are running in a
scale out environment, they are both stand alone servers. Any other ideas as
to my original error? "The feature: "Scale-out deployment" is not supported
in this edition of
Reporting Services. (rsOperationNotSupported) (rsRPCError)"

@@Version Output
=======================
Microsoft SQL Server 2005 - 9.00.3042.00 (X64) Feb 10 2007 00:59:02
Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on
Windows NT 5.2 (Build 3790: Service Pack 1)
--------------------------------------------
Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) Mar 23 2007 16:28:52
Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows
NT 5.2 (Build 3790: Service Pack 1)
========================

> Hi,
> I believe that Aaron has provided you good suggestions for explaining the
[quoted text clipped - 40 lines]
> This posting is provided "AS IS" with no warranties, and confers no rights.
> =========================================================

Reply to this Message

Charles Wang[MSFT] - 26 Mar 2008 03:09 GMT

Hi,
Thank you for letting us know this.

From the output, we can see that your two SQL Server 2005 instances are
both Standard Edition that does not support scale-out deployment. You can
find the clear description in the article I mentioned in my last response.
To get this feature, you have to migrate your SQL Server 2005 to SQL Server
2005 Enterprise Edition.

If you have any other questions or concerns, please feel free to let me
know. Have a nice day!

Best regards,
Charles Wang
Microsoft Online Community Support
=========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@microsoft.com.
=========================================================

Signature

This posting is provided "AS IS" with no warranties, and confers no rights.

=========================================================

Reply to this Message