the problem is solved,thank you.
"Andrea Montanari" <andrea.sqlDMO@virgilio.it> wrote in message
news:30ooiaF338jhdU1@uni-berlin.de...
> hi,
> "leighsword" <leighsword@163.net> ha scritto nel messaggio
> news:uF1Bfm60EHA.2884@TK2MSFTNGP11.phx.gbl
> > except Gunes.
> >
> > to install a new instance,such as "LeighSword",everythink is OK when
> > you have installed a Default instance.
> >
> > we have not trouble in install produce(because i have spends a lots
> > time to reseach it)
> > so what is the problem i have got?
> > the MSDE can able to connect using the OSQL.exe when i have not
> > installed a Default instance.
> >
> > i found we Miss the service ,MSSQLSERVER,only display MSSQL$LeighSword
> > service,the service is running and automatically through StartSevice
> > funciton.
> >
> > using "OSQL.exe Niceguy-W3606K8Y\LeighSword -E" get a error message.
> >
> > Why i need a Default instance before install a Named instance?
> >
> > god bless comment guy,god bless Amercia.
>
> actually I just installed, on WinXP pro sp1a a named instance... it's full
> name is XPE\MSDE or (Local)\MSDE with the following call to setup.exe:
> c:\..\>setup.exe INSTANCENAME=MSDE SECURITYMODE=SQL
> DISABLENETWORKPROTOCOLS=0 SAPWD=xxxxxxxx /L*v "C:\MSDELog.txt"
> and it works as expected...
> c:\>osql -S(Local)\MSDE -E
> can connect (again) as expected... it's the only (named) instance on that
> computer
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
>
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org > DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> --------- remove DMO to reply
>
