This article is about the issues where installation fails for service packs and hotfixes.&nb
MSDN article provides you the information about viewing and reading SQL Server setup log files )
In SQL Server 2008 R2 the error message is pretty much clear and concise but this is not the same with the SQL Server 2005.
We need to verify the setup log and there are scenarios where each time different MSP file was missing .
MSP error screenshot on 2008 R2 :
1) If MSP file is missing then we need to identify what is old patch applied.
2) Download that KB patch to Desktop and extract the files from command prompt. Please use following switch to extract PATCH or KB name/extract.
3) Go to extracted directory and copy ..\ hotfixsql\files\sqlrun_sql.msp
4) Paste it in C:\Windows\Installer and rename it to XXXX.msp.
5) Double check that 'C:\WINDOWS\Installer\XXXX.msp' exists now.
6) Run the setup and the patch will run successfully
MSI Error :
Sql Server Setup encountered following error : C:\Windows\Installer\XXXXX.MSI failed.
Resolution :
To resolve the issue copy SqlRun_SQL.msi from setup folder and rename it with the missing MSI file name and copy it into the location C:\Windows\Installer
If you encountered the following error: "Error: Setup fails with the error The patch installer has failed to update the shared features"
Resolution:
The problem occurs if Devenv.exe.config.tmp file is missing from the computer.
To work around this problem check for the following file devenv.exe.config.tmp in the following folder "C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies"
You may refer the following MSDN KB artcile for more information
http://support.microsoft.com/kb/2216468
