Problems with KB 934458

I attempted to install KB 934458 today, but the installation failed. Now, when I try to connect to my SQL server, I fail and get Microsoft SQL Server Error: 2. This error was not occurring until I attempted to install the today's hotfix (934458).

Anyone know of a workaround?

Workaround: If you don't have the issues that Update resolves, simply reboot and hide the update.

Details: I had the exact same issue. That update has tried to install itself 4 times on my machine - all unsuccessfullly. If I simply rebooted, I could access my server again. Here's the issues this is supposed to resolve:

Critical Update for SQL Server 2005 Service Pack 2 (KB 934458)

Download size: 18.2 MB

You may need to restart your computer for this update to take effect.

Update type: Important

The initial release of SQL Server 2005 Service Pack 2 (SP2) contained an issue that caused maintenance plan cleanup tasks to remove data before the specified cleanup interval. Install this update to correct the interpretation of existing cleanup task intervals, and to avoid this issue in new cleanup tasks. After you install this item, you may have to restart your computer.

More information:
http://support.microsoft.com/kb/934458

I don't have issues there, so I'll skip that update until it's fixed.

(I suspect you've already done this. I hope someone will post here if the update starts working.)|||On my machine it's even worse: I'm getting a BSOD every time I try to launch SQL Server tools, re-install SP2, the patch 934458, or uninstall any of that.

The whole installation is completely blocked and unusable now, and cannot even be uninstalled -- not even after I clean all SQL Server-related install entries using MS Installer Cleanup utility and try to re-apply SP2. BSOD after BSOD after BSOD.

The patch 934458 is the direct cause of the whole mess.

[EDIT]

There seem to be two different patches for the same issue:

http://www.sqlservercentral.com/columnists/sjones/2958_printversion.asp

I have installed my SQL Server and automatically applied SP2, and then had Windows Update telling me I should install 934458.

I guess I should have ignored that and installed the other one, 934459 (90+ MB), which is what I'm about to do right now (fingers crossed).

|||I had a heck of a hard time installing this hotfix, but finally discovered that the Hotfix updater was trying to make a temporary copy of the patch (and failing) to my F: drive, which is a virtual drive I have which maps to a subdirectory on my C: drive. I don't know why the Hotfix was choosing to go there instead of my typical default C: drive, but I was able to succeed in getting the install to work by temporarily removing my F: drive (via "subst /d f:" at a command prompt) and then rerunning the manual install.

This is clearly a bug in the Hotfix. Again, I was able to get the install to work just by unmapping my virtual drives.
|||Well my MSSQLServer will now not start after a reboot! Great fun. I downloaded 934458 and tired again after the windows update failure. It install success on all but database services. So until I find a fix my MSSQL is offline. Anyone have a suggestion?