Solved

The instance name specified is invalid

Posted on 2012-03-10
5
390 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
  • 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 500 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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

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…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

705 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now