Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I lost track of my account when my question was moved to superuser.

I wasn't able to install Microsoft SQL Server 2005 Express Edition SP4 through automatic update so I downloaded the update from here and tried manual install, which was also failed with some error:

The components that you are trying to install are already installed

I checked the product version of sql server 2005 which returned 9.00.5000.00 through command Select @@version.

Now the question is, if the automatic update wasn't able to apply the SP4 patch then how come the version is updated to 9.00.5000.00 ?

There is no way to rollback or reinstall the patch as it takes the entire SQL Server which came with Visual Studio 2005 to be re-installed.

Is there any other way I can verify that SP4 patch was properly applied?

Edit: I used MBSA Tool to analyze the required updates which confirms that the Microsoft SQL Server 2005 Express Edition SP4 is missing.

share|improve this question
I found this link helpful to troubleshoot the similar issues as I mentioned. Gonna give it a try. – user754334 Jun 28 '11 at 4:39

It is not clear what "it won't install" means, and I've also never heard of the updates coming out of order like that (the most recent usually supersedes older ones).

But you can install SP4 manually instead of relying on Windows Update:

share|improve this answer

They would need to be installed in order (sp2, sp3, sp4)

You got them as your PC must have SQLExpress installed.

share|improve this answer
SQL Server service packs are cumulative. If you are going to install SP4, there is no reason to install SP2 or SP3 at all. – Aaron Bertrand Jun 28 '11 at 1:48

I would say that since it is reporting the version number correctly (as in the document below), it is installed correctly unless you are getting some error. I cannot speculate as to how it got installed, but you seem to be on SP4.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .