?
Solved

The instance name specified is invalid

Posted on 2012-03-10
5
Medium Priority
?
434 Views
Last Modified: 2012-03-10
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
Comment
Question by:TownTalk
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 7

Expert Comment

by:markmiddlemist
ID: 37704871
Does it not allow you to leave the field blank? This is what I would expect for the default instance
0
 

Author Comment

by:TownTalk
ID: 37704877
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
 
LVL 7

Accepted Solution

by:
markmiddlemist earned 2000 total points
ID: 37704886
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
 

Author Comment

by:TownTalk
ID: 37704944
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
 
LVL 7

Expert Comment

by:markmiddlemist
ID: 37705641
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: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question