SQL Server 2008 KB2977321 Failed with Error code 1642
as part of application of security patches via windows update, sql server kb2977321 applied along number of os security patches. prior applying patches, stopped agent, engine, reporting, analysis , full text services.
the sql server build prior windows update (for both instances):
productversion productlevel edition
10.0.5500.0 sp3 standard edition (64-bit)
after update process, main instance showing (the second instance not in use yet , have left in stopped state)
microsoft sql server 2008 (sp3) - 10.0.5520.0 (x64)
jul 11 2014 16:11:50
copyright (c) 1988-2008 microsoft corporation
standard edition (64-bit) on windows nt 6.1 <x64> (build 7601: service pack 1) (vm)
in administrative logs after os patches applied (and reported successful windows update), found following errors listed:
log name: application
source: msiinstaller
date: 11/18/2014 7:16:45 pm
event id: 1024
task category: none
level: error
keywords: classic
user: system
computer: sjcdb3.intranet.co.st-johns.fl.us
description:
product: microsoft sql server 2008 database engine services - update '{9145cf54-462e-4a28-8fb5-a44c93ad3716}' not installed. error code 1642. windows installer can create logs troubleshoot issues installing software packages. use following link instructions on turning on logging support: http://go.microsoft.com/fwlink/?linkid=23127
event xml:
<event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<system>
<provider name="msiinstaller" />
<eventid qualifiers="0">1024</eventid>
<level>2</level>
<task>0</task>
<keywords>0x80000000000000</keywords>
<timecreated systemtime="2014-11-19t00:16:45.000000000z" />
<eventrecordid>1764186</eventrecordid>
<channel>application</channel>
<computer>sjcdb3.intranet.co.st-johns.fl.us</computer>
<security userid="s-1-5-18" />
</system>
<eventdata>
<data>microsoft sql server 2008 database engine services</data>
<data>{9145cf54-462e-4a28-8fb5-a44c93ad3716}</data>
<data>1642</data>
<data>(null)</data>
<data>(null)</data>
<data>(null)</data>
<data>
</data>
<binary>7b38373544383436332d313135422d343444322d414432352d3731454337453833423843437d207b39313435434635342d343632452d344132382d384642352d4134344339334144333731367d2031363432</binary>
</eventdata>
</event>
in c:\program files\microsoft sql server\100\setup bootstrap\log\20141118_191448\detail.txt file found following around time error reported
2014-11-18 19:16:30 slp: baseline package id sql_engine_core_inst_cpu64 - highest patch version 10.3.5500.0
2014-11-18 19:16:30 slp: patch id kb2977321_sql_engine_core_inst_cpu64 - notinstalled on baseline msi package sql_engine_core_inst_cpu64. detail description of patch package is: patchid=kb2977321_sql_engine_core_inst_cpu64 patchversion=10.3.5520.0 baselinepackageid=sql_engine_core_inst_cpu64 baselineversion=10.3.5500.0; patchfilename=sql_engine_core_inst.msp patchcode={9145cf54-462e-4a28-8fb5-a44c93ad3716}
2014-11-18 19:16:30 slp: patch id: kb2977321_sql_engine_core_inst_cpu32 - baseline msi not installed. the patch package ignored.
2014-11-18 19:16:30 slp: patch id: kb2977321_sql_engine_core_inst_cpu32 - detail description of patch package is: patchid=kb2977321_sql_engine_core_inst_cpu32 patchversion=10.3.5520.0 baselinepackageid=sql_engine_core_inst_cpu32 baselineversion=10.3.5500.0; patchfilename=sql_engine_core_inst.msp patchcode={9145cf54-462e-4a28-8fb5-a44c93ad3716}
2014-11-18 19:16:30 slp: baseline package id sql_rs_cpu64 - highest patch version 10.3.5500.0
2014-11-18 19:16:30 slp: patch id kb2977321_sql_rs_cpu64 - notinstalled on baseline msi package sql_rs_cpu64. detail description of patch package is: patchid=kb2977321_sql_rs_cpu64 patchversion=10.3.5520.0 baselinepackageid=sql_rs_cpu64 baselineversion=10.3.5500.0; patchfilename=sql_rs.msp patchcode={2296f7dd-2d3d-4802-b61a-ae7460efb767}
2014-11-18 19:16:30 slp: patch id: kb2977321_sql_rs_cpu32 - baseline msi not installed. the patch package ignored.
2014-11-18 19:16:30 slp: patch id: kb2977321_sql_rs_cpu32 - detail description of patch package is: patchid=kb2977321_sql_rs_cpu32 patchversion=10.3.5520.0 baselinepackageid=sql_rs_cpu32 baselineversion=10.3.5500.0; patchfilename=sql_rs.msp patchcode={2296f7dd-2d3d-4802-b61a-ae7460efb767}
2014-11-18 19:16:30 slp: baseline package id sql_is_cpu64 - highest patch version 10.3.5500.0
2014-11-18 19:16:30 slp: patch id kb2977321_sql_is_cpu64 - notinstalled on baseline msi package sql_is_cpu64. detail description of patch package is: patchid=kb2977321_sql_is_cpu64 patchversion=10.3.5520.0 baselinepackageid=sql_is_cpu64 baselineversion=10.3.5500.0; patchfilename=sql_is.msp patchcode={e870296c-24cc-4d82-bb59-cd136692e2bd}
2014-11-18 19:16:30 slp: baseline package id sql_bids_cpu64 - highest patch version 10.3.5500.0
2014-11-18 19:16:30 slp: patch id kb2977321_sql_bids_cpu64 - notinstalled on baseline msi package sql_bids_cpu64. detail description of patch package is: patchid=kb2977321_sql_bids_cpu64 patchversion=10.3.5520.0 baselinepackageid=sql_bids_cpu64 baselineversion=10.3.5500.0; patchfilename=sql_bids.msp patchcode={ea407fa6-c2d1-4d3d-9227-b9e06dddefd0}
2014-11-18 19:16:30 slp: baseline package id sql_ssms_cpu64 - highest patch version 10.3.5500.0
2014-11-18 19:16:30 slp: patch id kb2977321_sql_ssms_cpu64 - notinstalled on baseline msi package sql_ssms_cpu64. detail description of patch package is: patchid=kb2977321_sql_ssms_cpu64 patchversion=10.3.5520.0 baselinepackageid=sql_ssms_cpu64 baselineversion=10.3.5500.0; patchfilename=sql_ssms.msp patchcode={8a81b870-e8f0-415d-ac80-13beaa3ec8c8}
2014-11-18 19:16:30 slp: baseline package id: sql_common_core_cpu64 - no patches found sql discovery on installed package productcode {5340a3b5-3853-4745-bed2-dd9ff5371331}
2014-11-18 19:16:30 slp: patch id kb2977321_sql_common_core_cpu64 - notinstalled on baseline msi package sql_common_core_cpu64. detail description of patch package is: patchid=kb2977321_sql_common_core_cpu64 patchversion=10.3.5520.0 baselinepackageid=sql_common_core_cpu64 baselineversion=10.3.5500.0; patchfilename=sql_common_core.msp patchcode={cf023e0f-3a19-4dbf-bca3-0f664b447edb}
the instance came , seems operating normally. there error or kb installed correctly result of windows update process indicated? is there way can verify this?
hello,
please run discovery report , share results us.
http://blogs.msdn.com/b/petersad/archive/2009/11/13/sql-server-2008-discovery-report.aspx
you should never stop sql server services update sql server instance.
repairing failed installation may fix issues:
http://msdn.microsoft.com/en-us/library/cc646006(v=sql.100).aspx
hope helps.
regards,
alberto morillo
sqlcoffee.com
SQL Server > SQL Server Security
Comments
Post a Comment