I lost track of my account when my question was moved to superuser.
![Sql server Sql server](/uploads/1/2/6/1/126122091/147630065.jpg)
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: Along with SQL Server 2005 Service Pack 4 CTP, the Redmond company is also offering early adopters the possibility to test drive SQL Server 2005 Express Edition Service Pack 4 (SP4) CTP. This is a forum for Microsoft Lync issues rather than SQL issues. So you should ask your question in the SQL Server forum. However, it appears you need to run the installer under the administrator account. Try to download and apply SP4 manually. Run setup using “Run as Administrator” option.
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.
Community♦
user754334user754334
3 Answers
![Download Download](/uploads/1/2/6/1/126122091/210089187.png)
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).
Sql Server 2005 Express Sp1 Download
But you can install SP4 manually instead of relying on Windows Update:
Aaron BertrandAaron Bertrand
They would need to be installed in order (sp2, sp3, sp4)
You got them as your PC must have SQLExpress installed.
ChrisBintChrisBint
Windows Installer 3.1
Conan the barbarian 1982 online. 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.
KCotreauKCotreau