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


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

<div>
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:<br />
<br />
&nbsp;setup SAPWD=&quot;mypassword&quot;<br />
<br />
It all went downhill from there.
</div>


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.

<div>
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.<br />
<br />
Thanks again,<br />
<br />
Ian
</div>


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

<div>
Unfortunately their documentation back then wasn't the best. It is a lot better on more modern versions though.<br />
<br />
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.<br />
<br />
Best of luck<br />
<br />
Mark (@delradie)
</div>


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)

<div>
<div class="content wysiwyg-content">
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 &quot;The instance name specified is invalid&quot;<br />
<br />
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?
</div>
</div>


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?

The instance name specified is invalid

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.