We help IT Professionals succeed at work.

The instance name specified is invalid

TownTalk
TownTalk asked
on
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?
Comment
Watch Question

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

Author

Commented:
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.
Unfortunately I have no way of testing this but from a quick bit of searching the syntax would appear to be

setup /upgradesp sqlrun SECURITYMODE=SQL UPGRADEUSER=SA UPGRADEPWD=mypassword

Author

Commented:
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)

Explore More ContentExplore courses, solutions, and other research materials related to this topic.