updating SQL Server Express 2005 SP2 to SP3

I have a quick question about updating SQL Server 2005 Express SP2 to SP3.

Can I update to SP3 just by installing SQL Server 2005 Express SP3 on top of the current installation? I want to download and install this version:
http://www.microsoft.com/downloads/details.aspx?FamilyID=3181842a-4090-4431-acdd-9a1c832e65a6&displaylang=en

The current installation is running a couple of SQL instances. I want to make sure that the update will be smooth and no reconfiguration needed.

On the other hand - SQL updates for some reason are not detected by Windows Update. Is there any way to change it? I did not register with MS when I downloaded SQL Express (happy to do it now if that could help).

Thanks for your help!
itoranaAsked:
Who is Participating?
 
geek_vjConnect With a Mentor Commented:
itorana, you are right reg the updates. Please find the below link to check if it helps:

http://serverfault.com/questions/33954/why-does-windows-automatic-updates-ignore-sql-server-service-packs
0
 
Anthony PerkinsConnect With a Mentor Commented:
>>Can I update to SP3 just by installing SQL Server 2005 Express SP3 on top of the current installation?<<
Yes, you can update to SP3 by downloading and installing Service Pack 3.

>>On the other hand - SQL updates for some reason are not detected by Windows Update. <<
That is correct and the way it should be.

>>Is there any way to change it?<<
I hope not.
0
 
itoranaAuthor Commented:
Great, thank you for your answer.

I am not sure about Windows Update - here's info from MS website:

"Important notes for using Microsoft Update
When you use Microsoft Update to install SQL Server 2005 SP3, the installation is unattended unless components are clustered. If components are clustered, you must follow the prompts to complete the installation.
Microsoft Update upgrades all instances of SQL Server 2005 to SQL Server 2005 SP3. For example, if you have two instances of SQL Server 2005 that are running on the computer, both instances are upgraded to SQL Server 2005 SP3.
The SQL Server 2005 Express Edition updates are shown when you do an express scan and are available as an automatic update. The other editions of SQL Server are available as a custom update or as an optional update."
http://support.microsoft.com/kb/913089

I am not sure, but I understand that this means Windows Update should include SQL Server 2005 Express updates. What do you think?

0
 
itoranaAuthor Commented:
Thank you geek_vj - that was exactly it!
You just made it whole easier!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.