You may receive "Error 1316.A network error occurred while attempting to read from the file Path\SSCERuntime-ENU.msi" error message when you repair an instance SQL Server 2008

Article translations Article translations
Article ID: 970876 - View products that this article applies to.
Expand all | Collapse all
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.

Symptom



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:
    http://msdn.microsoft.com/en-us/library/cc646006.aspx
  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



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

                            Microsoft SQL Server 208 Release Notes                         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.

Cause



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.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Resolution



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

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

 

More Information



·          955396 How to troubleshoot SQL Server 2008 Setup issues

·          SQL Server Troubleshooting and Support

·          955965 Description of SQL Server Compact 3.5 Service Pack 1

 

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.

Properties

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
Keywords: 
kbrapidpub kbnomt KB970876

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com