Having trouble installing SQL Server 2005 SP2

The computer is a Windows 2003 R2 Enterprise 32-bit installed in a Windows
2003 R2 native AD domain/forest, and has WSUS/IIS6 running as well as SQL
Server 2005 standard. When trying to install it fails with the following
event log entry:
Event Type: Error
Event Source: Windows Update Agent
Event Category: Installation
Event ID: 20
Date: 3/8/2007
Time: 10:44:39 AM
User: N/A
Computer: BLACKDOG
Description:
Installation Failure: Windows failed to install the following update with
error 0x80070643: Microsoft SQL Server 2005 Service Pack 2 (KB 921896).
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 57 69 6e 33 32 48 52 65 Win32HRe
0008: 73 75 6c 74 3d 30 78 38 sult=0x8
0010: 30 30 37 30 36 34 33 20 0070643
0018: 55 70 64 61 74 65 49 44 UpdateID
0020: 3d 7b 41 37 46 46 45 42 ={A7FFEB
0028: 45 33 2d 41 46 34 43 2d E3-AF4C-
0030: 34 32 38 46 2d 41 34 44 428F-A4D
0038: 38 2d 33 38 41 41 36 46 8-38AA6F
0040: 39 38 35 37 36 32 7d 20 985762}
0048: 52 65 76 69 73 69 6f 6e Revision
0050: 4e 75 6d 62 65 72 3d 31 Number=1
0058: 30 31 20 00 01 .
Any help debugging this would be appreciated.
--
Edward Ray
CCIE Security, CISSP, GCIA Gold, GCIH Gold, MCSE+Security, PEHi, Edward,
I understand that the SQL Server 2005 SP2 failed to be installed on your
Windows 2003 R2 Enterprise Edition running SQL Server 2005 STD. The error
code is 0x80070643.
If I have misunderstood, please let me know.
The error code indicates that fatal error during the installation.
Unfortunately we could not get more information from this message.
Could you please mail me the installation logs ( C:\WINDOWS\Hotfix ) for
further research? My email address is changliw_at_microsoft_dot_com.
If the hotfix logs were not generated, I recommend that you use FileMon amd
RegMon to monitor the SP2 setup progress and mail me the logs for further
research.
Best regards,
Charles Wang
Microsoft Online Community Support
=====================================================Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
If you are using Outlook Express, please make sure you clear the check box
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
======================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||i got this same error. would be very interested to hear any
explanation and/or workaround. i can provide whatever info is needed,
but i already submitted it via the windows crash feedback thing.
many thanks
tim|||As per your request I have sent you the error and filemon logs.
Edward Ray
CCIE Security, CISSP, GCIA Gold, GCIH Gold, MCSE+Security, PE
"Charles Wang[MSFT]" <changliw@.online.microsoft.com> wrote in message
news:MXO8hufYHHA.2372@.TK2MSFTNGHUB02.phx.gbl...
> Hi, Edward,
> I understand that the SQL Server 2005 SP2 failed to be installed on your
> Windows 2003 R2 Enterprise Edition running SQL Server 2005 STD. The error
> code is 0x80070643.
> If I have misunderstood, please let me know.
> The error code indicates that fatal error during the installation.
> Unfortunately we could not get more information from this message.
> Could you please mail me the installation logs ( C:\WINDOWS\Hotfix ) for
> further research? My email address is changliw_at_microsoft_dot_com.
> If the hotfix logs were not generated, I recommend that you use FileMon
> amd
> RegMon to monitor the SP2 setup progress and mail me the logs for further
> research.
> Best regards,
> Charles Wang
> Microsoft Online Community Support
> =====================================================> Get notification to my posts through email? Please refer to:
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications
> If you are using Outlook Express, please make sure you clear the check box
> "Tools/Options/Read: Get 300 headers at a time" to see your reply
> promptly.
>
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ======================================================> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ======================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> ======================================================>
>
>|||Hi, Edward,
Thanks for your email response.
I checked your FileMon log, and found many errors like the following:
5473 11:14:52.094 PM svchost.exe:1680 FASTIO_QUERY_OPEN C:\Program
Files\Microsoft SQL Server\90\DTS\Binn\SRCLIENT.DLL NOT FOUND Attributes:
Error
5474 11:14:52.094 PM svchost.exe:1680 FASTIO_QUERY_OPEN C:\Program
Files\Microsoft SQL Server\90\Tools\binn\SRCLIENT.DLL NOT FOUND Attributes:
Error
5475 11:14:52.094 PM svchost.exe:1680 FASTIO_QUERY_OPEN C:\Program
Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SRCLIENT.DLL
NOT FOUND Attributes: Error
Also, from the log:
102 11:14:44.058 PM svchost.exe:1680 FASTIO_DEVICE_CONTROL
C:\WINDOWS\SoftwareDistribution\DataStore\Logs FAILURE IOCTL: 0x4D0008
It indicates that not enough storage is available to process this command.
Could you please check if the files paths are existed and if there is
enough disk space during the setup process?
Best regards,
Charles Wang
Microsoft Online Community Support
=====================================================Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
If you are using Outlook Express, please make sure you clear the check box
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
======================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||Charles, please help!
My problem is almost the same as Edward's. I have tried more than 5 times
to install the Microsoft SQL Server 2005 Express Edition Service pack and
every time I get the message: Updates were unable to be successfully
installed.
I have no error code: none comes up. I also have no hotfix file in the
Windows directory. What is filemon? How do I access it to give you more
info?
My computer has also been running slower since I installed Office 2007, but
I know that's another issue. It freezes if it has been on for awhile, and
programs are slow to open and close. I maintain my computer, I have all the
necessary virus, firewall, spyware, whatever -- so what could be the problem?
My computer is a Dell, about 8 months old, running with XP Media edition.
Thanks for your help. I am getting desperate.
Thanks,
Marla
"Charles Wang[MSFT]" wrote:
> Hi, Edward,
> Thanks for your email response.
> I checked your FileMon log, and found many errors like the following:
> 5473 11:14:52.094 PM svchost.exe:1680 FASTIO_QUERY_OPEN C:\Program
> Files\Microsoft SQL Server\90\DTS\Binn\SRCLIENT.DLL NOT FOUND Attributes:
> Error
> 5474 11:14:52.094 PM svchost.exe:1680 FASTIO_QUERY_OPEN C:\Program
> Files\Microsoft SQL Server\90\Tools\binn\SRCLIENT.DLL NOT FOUND Attributes:
> Error
> 5475 11:14:52.094 PM svchost.exe:1680 FASTIO_QUERY_OPEN C:\Program
> Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SRCLIENT.DLL
> NOT FOUND Attributes: Error
> Also, from the log:
> 102 11:14:44.058 PM svchost.exe:1680 FASTIO_DEVICE_CONTROL
> C:\WINDOWS\SoftwareDistribution\DataStore\Logs FAILURE IOCTL: 0x4D0008
> It indicates that not enough storage is available to process this command.
> Could you please check if the files paths are existed and if there is
> enough disk space during the setup process?
> Best regards,
> Charles Wang
> Microsoft Online Community Support
> =====================================================> Get notification to my posts through email? Please refer to:
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications
> If you are using Outlook Express, please make sure you clear the check box
> "Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.
>
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ======================================================> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ======================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================>
>