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.
Consider the following scenario:
You install Microsoft Visual Studio 2008 Service Pack 1.
You install Microsoft SQL Server 2008 side by side with Visual Studio 2008 Service Pack 1.
You try to repair the SQL Server 2008 instance, using Add or Remove Programs feature in Control Panel.
Note For more information about how to repair a failed SQL Server 2008 installation, visit the following Microsoft Developer Network (MSDN) Web site:
The issue will also happen with the release version of Visual Studio, but as noted in the release notes, SQL Server 2008 requires Service Pack 1 for Visual Studio 2008 if you need to use Management tools, Integration services and Business Intelligence Development studio features.
This issue also exists in the upcoming release SQL Server 2008 R2.
Visual Studio 2008 SP1 and SQL Server 2008 shipped the same MSI package for SSCE runtime but with different file names. SQL Server shipped it as SSCERuntime.msi while Visual Studio 2008 SP1 shipped it as SSCERuntime-enu.msi. During the repair operation, Windows installer tries to change the name of the MSI shipped with Visual Studio.net to the one that is shipped with SQL. Because Windows installer does not allow this, the repair operation fails with the error mentioned in the symptom section.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
To resolve this problem, follow these steps:
1. Remove Microsoft SQL Server Compact 3.5 SP1 <Language> using Add or Remove Programs feature in Control Panel.
2. Rerun the repair operation for SQL Server 2008. After the repair operation, SQL Server Compact 3.5 SP1 <Language>is reinstalled on the system.
How to: Repair a Failed SQL Server 2008 Installation
· 955965 Description of SQL Server Compact 3.5 Service Pack 1
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.
Microsoft SQL Server 2008 Workgroup, Microsoft SQL Server 2008 Web, Microsoft SQL Server 2008 Standard Edition for Small Business, Microsoft SQL Server 2008 Standard, Microsoft SQL Server 2008 Express with Advanced Services, Microsoft SQL Server 2008 Express, Microsoft SQL Server 2008 Enterprise, Microsoft SQL Server 2008 Developer, Microsoft Visual Studio Team System 2008 Team Suite, Microsoft Visual Studio Team System 2008 Database Edition, Microsoft Visual Studio Team System 2008 Architecture Edition, Microsoft Visual Studio Team System 2008 Development Edition, Microsoft Visual Studio Team System 2008 Test Edition, Microsoft Visual Studio 2008 Service Pack 1, Microsoft Visual Studio 2008 Standard Edition, Microsoft Visual Studio 2008 Professional Edition, Microsoft Visual Basic 2008 Express Edition, Microsoft Visual C# 2008 Express Edition