• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 454
  • Last Modified:

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?
0
TownTalk
Asked:
TownTalk
  • 3
  • 2
1 Solution
 
markmiddlemistCommented:
Does it not allow you to leave the field blank? This is what I would expect for the default instance
0
 
TownTalkAuthor 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.
0
 
markmiddlemistCommented:
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
0
 
TownTalkAuthor 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
0
 
markmiddlemistCommented:
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)
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now