Microsoft SQL Server 2005 Express Edition Service Pack 2 (KB 92189

I have tried to install this update 5 times now, and each time it has taken
20 minutes and then failed.

The Update History gives this error:
Installation Failure

Error Code: 0x80041001
Try to install the update again, or request help from one of the following
resources.

For self-help options:

Frequently Asked Questions
Find Solutions
Windows Update Newsgroup

For assisted support options:


Microsoft Online Assisted Support (no-cost for issues related to getting
updates)

I am having the same problem. I haven't had a chance to check this yet. But I
found a possible cause in Article ID : 933097.

Important notes about the cumulative hotfix package
• You must enable the SQL Server Management Object (SMO) extended stored
procedures and the SQL Server Distributed Management Object (SQL-DMO)
extended stored procedures before you install the cumulative hotfix package.
For more information about the SMO and DMO XPs option, see SQL Server 2005
Books Online.

Note SQL Server 2005 Books Online notes that the default setting of these
stored procedures is 0 (off). However, this value is incorrect. By default,
the setting is 1 (on).


"Tempus" wrote:

> I have tried to install this update 5 times now, and each time it has taken
> 20 minutes and then failed.
>
> The Update History gives this error:
> Installation Failure
>
> Error Code: 0x80041001
> Try to install the update again, or request help from one of the following
> resources.
>
> For self-help options:
>
> Frequently Asked Questions
> Find Solutions
> Windows Update Newsgroup
>
> For assisted support options:
>
>
> Microsoft Online Assisted Support (no-cost for issues related to getting
> updates)