Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQLTechnet

Vinoth is currently a Senior SQL Server DBA and 10 years of experience as SQL Server DBA. Started my career as a DBA in SQL 6.5/7 has worked in all subsequent SQL Server version. Vinoth has worked in some of the largest SQL server environments in the world in various domains ranging from Finance, Retail, Manufacturing, Consulting, Web etc. Vinoth has Engineering Degree in Computer Science and has certified in MCITP - Database Adminstrator in 2008/2005, MCDBA and ITIL Foundation V3.

Service pack Native Client, SQL XML4 and VSSWriter failed


One of my client accidentally executed a 32 bit service pack on a 64 bit SQL Server, the service Pack failed with an error to execute 64 bit version of the service pack.
We then tried to execute 64 bit version of service pack which completed successfully for database services but failed for  Native Client, SQL XML4 and VSSWriter with the below Error.
----------------------------------------------------------------------------------
Product                   : SQL Server Native Client

Product Version (Previous): 5000

Product Version (Final)   : 

Status                    : Failure

Log File                  : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB2463332_sqlncli.msi.log

Error Number              : 1316

Error Description         : MSP Error: 1316  A network error occurred while attempting to read from the file: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\Cache\sqlncli_x64.msi
----------------------------------------------------------------------------------
Product                   : SQLXML4

Product Version (Previous): 5000

Product Version (Final)   : 

Status                    : Failure

Log File                  : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB2463332_sqlxml4.msi.log

Error Number              : 1316

Error Description         : MSP Error: 1316  A network error occurred while attempting to read from the file: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\Cache\sqlxml4_x64.msi

----------------------------------------------------------------------------------
Product                   : Microsoft SQL Server VSS Writer
Product Version (Previous): 5000

Product Version (Final)   : 

Status                    : Failure

Log File                  : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB2463332_SqlWriter.msi.log

Error Number              : 1316

Error Description         : MSP Error: 1316  A network error occurred while attempting to read from the file: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\Cache\SqlWriter_x64.msi

----------------------------------------------------------------------------------
Summary
     One or more products failed to install, see above for details

     Exit Code Returned: 1316


Resolution:
This issue happens because the 32 bit install copies 32 bit file version sqlncli.msi, SqlWriter.msi and
sqlxml4 to C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\Cache\ from where the service pack
executes the file. We need to manually copy the 64 bit version of the files sqlncli_x64.msi, SqlWriter_x64.msi and
sqlxml4_x64.msi before we execute the 64 bit service pack to prevent this issue. Use the VB Script mentioned in http://support.microsoft.com/kb/969052
and analyse the log file for line "Action needed" which will give you the source path of the files that need to be copied to
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\Cache\ Once the files are copied your 64 bit install should go through fine.

Comments

Leave a comment on the original post [www.sqltechnet.com, opens in a new window]

Loading comments...