SQL Server 2000 SP4 Upgrade Issue

Hello, I have MSDE 2000 (sp2) installed on a Windows Server 2003 server.  When attempting to upgrade to sp4 (with SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE), I get the following message and the upgrade stops:

The instance name specified is invalid.

I am wondering if sp3 has to be installed before installing sp4.  If not, I am out of ideas as to what is causing this issue.  

Here is the server's SQL version information:

Microsoft SQL Server  2000 - 8.00.760 (Intel X86)   Dec 17 2002 14:22:05   Copyright (c) 1988-2003 Microsoft Corporation  Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 2)


Thank you in advance.

Karl
karlhscAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

jaynirCommented:
I think you need to install sp3 before you install sp4.
0
SimpsonThePhilCommented:
Look at the command line options, I'm sure there is a switch for the instance name
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

karlhscAuthor Commented:
I have tried running the following...

c:\myfolder\>setup.exe /upgradesp SQLRUN INSTANCENAME=myinstanceName /L*v  
 
"c:\msdeupg.txt"  

...and adding the following to the setup.ini file (as an option)...

INSTANCENAME=myinstancename

...but all of these possible fixes resulted in the same message.

Also, I attempted to install sp3 and the same message appeared.
0
karlhscAuthor Commented:
One other thing: I have setup a password for sa
0
karlhscAuthor Commented:
I got it working- I needed to have been installing via the command line instead of through a sql query.  Thank you for the help.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.