Link to home
Create AccountLog in
Avatar of TownTalk
TownTalkFlag for United Kingdom of Great Britain and Northern Ireland

asked on

The instance name specified is invalid

I've got the MSDE 2000 installed on my pc at home. I want to install sp4 which I got from the download center. When I run it I get the error "The instance name specified is invalid"

When I originally installed MSDE, I did not specify an instance name. I've tried specifying instance names of Defaultsance, MSDE, MSDE$ I dont know what else I can try?
Avatar of markmiddlemist
markmiddlemist
Flag of United Kingdom of Great Britain and Northern Ireland image

Does it not allow you to leave the field blank? This is what I would expect for the default instance
Avatar of TownTalk

ASKER

No, that's what I tried first. You have to run setup from the command prompt and supply the sa password. So initially i typed:

 setup SAPWD="mypassword"

It all went downhill from there.
ASKER CERTIFIED SOLUTION
Avatar of markmiddlemist
markmiddlemist
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Yes that's worked thank you, but the accompanying documentation made no mention of that command line. It just told me to use the one I posted above unless I needed to specify a particular instance.

Thanks again,

Ian
Unfortunately their documentation back then wasn't the best. It is a lot better on more modern versions though.

Is there a specific reason you're still using 2000 - sql express 2008 R2 really is a LOT better. I'm guessing there is a good reason though.

Best of luck

Mark (@delradie)