Service Pack 4 for SQL 2000

Question

Service Pack 4 for SQL 2000

Peter Reisler

SSC Journeyman

Points: 78
More actions
February 16, 2007 at 1:12 pm

#62541

Hi!
I have tried installing service pack 4 for sql 2000. I have encountered a problem while applying the sp4 for the msde part. At first it would not install because it required a stong sa password. I modified the setup.ini in an attempt to rectify the problem. I now get the following error messaage: The instance name specified is invalid.
Can anyone help with this? I would appreciate it. Thanks in advance for your help.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

SQLBill SSC Guru Points: 51440 More actions · Answer 1

You say you are installing the MSDE part, the database is MSDE not Standard or Enterprise edition correct?

How many instances do you have? How did you provide the name of the instance? If it is a named instance, you need to provide the server name (\\servername\instancename).

-SQLBill

Peter Reisler SSC Journeyman Points: 78 More actions · Answer 2

Here is what my ini file looks like:

[Options]

SAPWD="nochange"

TARGETDIR="C:\Program Files\Microsoft SQL Server\Mssql$Mssqlserver$RPMS\Binn\"

DATADIR="D:\Mssql\Mssql$RPMS\Data\"

INSTANCENAME="\\FHDP1IRMPA01\RPMS"

When I go to install it still tells me instance name is invalid.

Does anyone have any ideas?

Thanks,

Peter

vineet Raut SSC Eights! Points: 813 More actions · Answer 3

The entry for the instance name looks to be incorrect. I think SQLBill typed it by mistake.

The correct entry should be something like

INSTANCENAME="FHDP1IRMPA01\RPMS"

i.e. machinename\instanceName

Peter Reisler SSC Journeyman Points: 78 More actions · Answer 4

Thanks for the tip but it still gives me instance name invalid.

Thanks,

Peter