Solved

The instance name specified is invalid

Posted on 2012-03-10
5
427 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 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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

696 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