While installing security patch KB 948109 on the sql server 2005, the installation of the patch may fail. In order to find the cause of the failure we need to look into the setup bootstrap logs which are located in the following location
C:Progarm FilesMicrosoft Sql Server90Setup BootstrapLOGHotfixSummary.txt
One of the cause of the failure can be Error 29527 which is reported in the summary.txt as shown
Following error reported in the sumary.txt
· **********************************************************************************
· Product Installation Status
· Product : SQL Server Database Services 2005 (ACT7)
· Product Version (Previous): 3042
· Product Version (Final) :
· Status : In Progress
· Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB948109_sqlrun_sql.msp.log
· SQL Express Features :
· Error Number : 29527
CAUSE:
====================
The issue is caused due to improper installation of support files as there may be missing files and dll’s in the 90 folder located in
c:program filesMicrosoft sql server90
RESOLUTION/WORKAROUND:
====================
We need to install a new instance of the sql server of the same edition and same built on the same system on which the original instance which need to be patched lies (i.e with required Service pack ) side by side which populates the 90 folder with correct files and dll’s.
Alternatively, we can also reinstall the support files by running the SqlSupport.msi file located in the media for sql server 2005 setup.
The SqlSupport.msi is generally located in <cd-drive>:serversSetupSqlSupport.msi
After installing the new instance or reinstalling the Support files by running SqlSupport.msi
We need to install security patch 948109 on the original instance on which it was failing previously, the installation of the security patch will succeed.