asked on

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

jaynir

I think you need to install sp3 before you install sp4.

ASKER CERTIFIED SOLUTION

SimpsonThePhil

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

jaynir

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

karlhsc

ASKER

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.

karlhsc

ASKER

One other thing: I have setup a password for sa

karlhsc

ASKER

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.