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 : 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 : 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
----------------------------------------------------------------------------------
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
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.
