Thursday, 9 August 2012

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.

No comments:

Post a Comment