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:
Â
In this scenario, the repair action will fail, and you receive the following error message:
Error 1316.A network error occurred while attempting to read from the file Path\SSCERuntime-ENU.msi
For more help, visit the following Microsoft Web site:
http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.0.1600.22&EvtType=0xDF039760%25401201%25401
(http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.0.1600.22&EvtType=0xDF039760%25401201%25401)
Notes- The issue will also happen with the release version of Visual Studio, but as noted in the release notes
(http://download.microsoft.com/download/4/9/e/49eeb41a-a769-4520-80d6-671b8ae2bd06/SQLServer2008ReleaseNotes.htm)
, 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.
                       Microsoft SQL Server 208 Release Notes
                       http://download.microsoft.com/download/4/9/e/49eeb41a-a769-4520-80d6-671b8ae2bd06/SQLServer2008ReleaseNotes.htm
(http://download.microsoft.com/download/4/9/e/49eeb41a-a769-4520-80d6-671b8ae2bd06/SQLServer2008ReleaseNotes.htm)
- 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.
STATUSMicrosoft 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
(http://msdn.microsoft.com/en-us/library/cc646006.aspx)
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
http://msdn.microsoft.com/en-us/library/cc646006.aspx
(http://msdn.microsoft.com/en-us/library/cc646006.aspx)
Note <Language> is a placeholder for the language of
SQL Server Compact 3.5. For example, ENU is for English, and JPN is for Japanese.
If you experience any problems reinstalling the compact edition through the repair option, you can install the compact edition using the setup files that are available in the Servers\Setup folder on the SQL Server 2008 installation media. You can also download SQL Server Compact 3.5 SP1 from the following Microsoft Download Center Web site:
http://www.microsoft.com/downloads/details.aspx?FamilyId=DC614AEE-7E1C-4881-9C32-3A6CE53384D9&displaylang=en
(http://www.microsoft.com/downloads/details.aspx?FamilyId=DC614AEE-7E1C-4881-9C32-3A6CE53384D9&displaylang=en)
Â
·        Â
955396
(http://kbalertz.com/Feedback.aspx?kbNumber=955396)
How to troubleshoot SQL Server 2008 Setup issues ·        Â
SQL Server Troubleshooting and Support
(http://msdn.microsoft.com/en-us/sqlserver/bb895923.aspx)
·        Â
955965
(http://support.microsoft.com/default.aspx?scid=kb;en-us;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.
Article ID: 970876 - Last Review: December 16, 2009 - Revision: 2.0
APPLIES TO
- 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
| kbrapidpub kbnomt KB970876 |