Select the product you need help with

SQL Server 2008 specific folders are created on systems with SQL Server 2005 starting SP3 and above to prevent upgrade failures to SQL Server 2008 at a later time

Article ID: 970669 - View products that this article applies to.

Source: Microsoft Support

RAPID PUBLISHING

RAPID PUBLISHING ARTICLES PROVIDE INFORMATION DIRECTLY FROM WITHIN THE MICROSOFT SUPPORT ORGANIZATION. THE INFORMATION CONTAINED HEREIN IS CREATED IN RESPONSE TO EMERGING OR UNIQUE TOPICS, OR IS INTENDED SUPPLEMENT OTHER KNOWLEDGE BASE INFORMATION.

Back to the top | Give Feedback

Symptom

After you install SQL Server 2005 Service Pack 3 (SP3) or later versions, you will notice an additional folder created under C:\Program Files\Microsoft SQL Server as follows:

C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Release\<platform specific>

This folder will have an updated SQL Server 2008 version of the Microsoft.SqlServer.Configuration.RSExtension.dll

Back to the top | Give Feedback

Cause

Because of a known bug with SQL Server 2008 setup process, the upgrade process would fail with the error listed in the More Information section below, if the updated version of the DLL is not present on the system that is hosting the instance to be upgraded. This is due to the fact the Reporting services configuration extension that ships with SQL Server 2008 installation media, does not recognize anything after SQL 2005 SP2 (9.x.3042) as a valid version for upgrade.

Back to the top | Give Feedback

Resolution

Microsoft recommends that you do not delete the folder and the files mentioned in the Symptoms section, to prevent failures during a future upgrade to SQL Server 2008. Deleting these files will require you to reinstall Service Pack 3 (SP3) or later builds available for SQL Server 2005 at the time of upgrade for a successful upgrade from SQL Server 2005 to SQL Server 2008.

Back to the top | Give Feedback

More Information

Without the fixed version of the DLL in the specific folder, the upgrade from SQL Server 2005 SP3 and higher builds will fail with the following error messages logged in the SQL Server 2008 setup error log:

2009-03-15 23:49:10 Slp: Configuration action failed for feature RS_Server_Adv during timing MergeConfig and scenario MergeConfig.

2009-03-15 23:49:10 Slp: Uknown version

2009-03-15 23:49:10 Slp: Configuration action failed for feature RS_Server_Adv during timing MergeConfig and scenario MergeConfig.

2009-03-15 23:49:10 Slp: System.ApplicationException: Uknown version

2009-03-15 23:49:10 Slp:    at Microsoft.SqlServer.Configuration.RSExtension.Helper.GetRSVersion(Version version)

2009-03-15 23:49:10 Slp:    at Microsoft.SqlServer.Configuration.RSExtension.SQLRSConfigurationPrivate.Upgrade_MergeConfig(Dictionary`2 actionData, PublicConfigurationBase spcb, Version version)

2009-03-15 23:49:10 Slp:    at Microsoft.SqlServer.Configuration.RSExtension.SQLRSConfigurationPrivate.UpgradeImpl(ConfigActionTiming timing, Dictionary`2 actionData, PublicConfigurationBase spcbCurrent, Version fromVersion)

2009-03-15 23:49:10 Slp:    at Microsoft.SqlServer.Configuration.SqlConfigBase.SqlFeatureConfigBase.Execute(ConfigActionScenario scenario, ConfigActionTiming timing, Dictionary`2 actionData, PublicConfigurationBase spcbCurrent)

2009-03-15 23:49:10 Slp:    at Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.ExecuteAction(String actionId)

2009-03-15 23:49:10 Slp:    at Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.Execute(String actionId, TextWriter errorStream)

2009-03-15 23:49:10 Slp: Exception: System.ApplicationException.

2009-03-15 23:49:10 Slp: Source: Microsoft.SqlServer.Configuration.RSExtension.

Back to the top | Give Feedback

DISCLAIMER

MICROSOFT AND/OR ITS SUPPLIERS MAKE NO REPRESENTATIONS OR WARRANTIES ABOUT THE SUITABILITY, RELIABILITY OR ACCURACY OF THE INFORMATION CONTAINED IN THE DOCUMENTS AND RELATED GRAPHICS PUBLISHED ON THIS WEBSITE (THE “MATERIALS”) FOR ANY PURPOSE. THE MATERIALS MAY INCLUDE TECHNICAL INACCURACIES OR TYPOGRAPHICAL ERRORS AND MAY BE REVISED AT ANY TIME WITHOUT NOTICE.

TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW, MICROSOFT AND/OR ITS SUPPLIERS DISCLAIM AND EXCLUDE ALL REPRESENTATIONS, WARRANTIES, AND CONDITIONS WHETHER EXPRESS, IMPLIED OR STATUTORY, INCLUDING BUT NOT LIMITED TO REPRESENTATIONS, WARRANTIES, OR CONDITIONS OF TITLE, NON INFRINGEMENT, SATISFACTORY CONDITION OR QUALITY, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE, WITH RESPECT TO THE MATERIALS.

Back to the top | Give Feedback