Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I'm trying to install SP3 on an install of Sql Server 2005 running on Server 2003 32 bit. When I run the installer it doesn't seem to recognize that I have SQL Server 2005 installed. The dialog box that asks what features should be updated doesn't show any by default. More troubling, it doesn't allow me to check any of those boxes to update features like Database Services or Reporting Services.

When I select one of these services, the "Status" box says "Not Valid". The message says something about more recent updates, but Select @@Version gives me this:

Microsoft SQL Server 2005 - 9.00.4053.00 (Intel X86) May 26 2009 14:24:20 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

Screenshot

share|improve this question

1 Answer 1

Just tossing this out there, but my knee-jerk response is to try the installation from safe mode.

Edit: Have you fully updated Windows? Have you tried stopping the SQL related services prior to upgrading? The installer should handle this kind of stuff, just trying to think of anything that may help ya..

share|improve this answer
1  
The Windows Installer service won't run in Safe Mode without some additional coaxing. –  jscott Jun 21 '11 at 23:05
    
I haven't tried safe mode. My best shot at this point is to come in on a Sunday and uninstall and then reinstall Sql Server from scratch. –  John Hoge Jun 23 '11 at 17:50
    
Obviously you wanna make sure you have a really reliable backup of your database contents - provided there is any. Obviously obvious, indeed. –  Doc Jun 23 '11 at 18:05

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.