Reinstall sql 2005 sp2

Worked for me. I know there's a hotfix and a service pack but that's not the point. The point is the hotfix was posted in Oct of It would be really nice if the SQL server team could be aware of this issue and writing a LaunchCondition in their install to prevent customer machines from blue screening.

Thanks for reporting this, and including the link to further information. Microsoft states that the hotfixes should only be applied "to systems that are experiencing this specific problem". So, what is a bootstrapper supposed to? By the time a machine experiences the problem, the bootstrapper has lost control to a perpetual reboot. Is there any logical test that it can perform to determine ahead of time that the operating system is vulnerable?

It sure looks like the hassle of upgrading far outweighs the risk of not upgrading. I installed it many many times , some on cluster and no single failure. The Setup presents a dialog with several options, you click Next a time or two and then you're presented with a screen in which you can click Test to test your SQL Server database connection and report server, in my case.

So the machine simply reboots ad infinitum. Operating systems aside, what the hell is wrong with Microsoft to not identify and FIX this issue? The question that you often face is should I install this service pack. One thing to note before you install SP2 is that there is no way to uninstall it once it is installed. With SQL Server there is no easy way to uninstall the service packs.

Following are links to the SQL Server services packs readme files and uninstall steps. As you can see, a rollback from an SP2 installation requires a complete reinstall of the SQL Server instance - something to definitely take into consideration for planning your update to SP2. Reinstall SQL Server Apply any hotfixes that were previously installed.

Not sure if you have resolved this issue or not. I had my sitting around for almost a year and finally did something about it last night. You receive this error when the previous upgrade has not completed successfully. The message would be: "SQL Server Setup cannot upgrade the specified instance because the previous upgrade did not complete.

When doing this the original temp folder setup by the installation had been removed from the server so I had to back up my databases and do a complete new reinstall. One of two apps have gone a bit awry but we are working with the vendor to reconnect it.

Everthing updates now. To continue this discussion, please ask a new question. Spiceworks Help Desk. The help desk software for IT. Track users' IT needs, easily, and with only the features you need. Learn More ». Get answers from your peers along with millions of IT pros who visit Spiceworks. Error Code: 0xD I have searched many forums but I can't seem to find an answer. Does anybody have any tips on getting this update installed?

Thanks in advance for any help..