October 28, 2009 at 4:18 pm
Hello, I have a SQL Server 2005 SP2 on a 64-bit Windows 2003 R2 Server. I noticed in the event log errors like:
Windows failed to install the following update with error 0x80070643: Microsoft SQL Server 2005 Service Pack 3 (KB955706).
I have the NT AUTHORITY\SYSTEM account with the sysadmin role in the SQL Server. However, the error still occurs when WSUS tries to run the upgrade for SP3.
Any suggetions on what might be causing the problem?
Some more of the error in the event log:
Event Type: Error
Event Source: Windows Update Agent
Event Category: Installation
Event ID: 20
Date: 6/16/2009
Time: 4:45:20 AM
User: N/A
Computer: TOMLINSON
Description:
Installation Failure: Windows failed to install the following update with error 0x80070643: Microsoft SQL Server 2005 Service Pack 3 (KB955706).
October 28, 2009 at 4:25 pm
This is known issue..
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQLServer\MSSQL.1\Setup\Resume
Change the Registry key value from 1 to 0.
October 28, 2009 at 4:40 pm
Thanks, I have:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.2\Setup
I don't have a MSSQL.1.
Found the Resume value to already be a 0. Any other suggestions?
October 28, 2009 at 5:06 pm
personally I would not leave applying service packs up to wsus. What about closing down apps before the install and backing up the system databases so you have a backout?
As for the cause check the log the service pack creates, the exact name escapes me but its in the program files directory for SQL under something like 90\setup\bootstrap.
Not being able to get exclusive access is one possibility.
---------------------------------------------------------------------
October 29, 2009 at 2:58 am
george sibbald-364359 (10/28/2009)
personally I would not leave applying service packs up to wsus. What about closing down apps before the install and backing up the system databases so you have a backout?As for the cause check the log the service pack creates, the exact name escapes me but its in the program files directory for SQL under something like 90\setup\bootstrap.
Not being able to get exclusive access is one possibility.
I could not agree more. WSUS is good but patching but SQL Server needs the human touch. 😎
I personally wouldn't let WSUS automatically install anything on a server. Advertise updates, yes but download and installation by an admin in a controlled fashion if you please.
Hope this helps.
October 29, 2009 at 10:03 am
Thanks for the advice. I will install SP3 myself.
For looking at the log files, I see these folders:
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\Log\Hotfix
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\Log\Files
However, I see in the Hotfix folder some log files for hotfixes, but can't find entries for when WSUS tried to install SP3. 3
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply