asked on 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?
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?
Microsoft SQL Server
Last Comment
markmiddlemist
Does it not allow you to leave the field blank? This is what I would expect for the default instance
ASKER
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.
setup SAPWD="mypassword"
It all went downhill from there.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
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
Thanks again,
Ian
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)
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)