MSDE

I trying install MSDE 2000 for the first time on XP Sp2
When I try run setup it give error Instance name is invaild
only choice click ok. When I click it just goes away.
I now how do fix I just double clicking setup icon
Thanks for the help
hi Frank,
frank wrote:
> I trying install MSDE 2000 for the first time on XP Sp2
> When I try run setup it give error Instance name is invaild
> only choice click ok. When I click it just goes away.
> I now how do fix I just double clicking setup icon
>
> Thanks for the help
can you please post your command line you used to install MSDE?
MSDE must be installed using it's setup.exe boostrap installer, which
accepts (and requires) some parameters...
all usable parameters for installing a (somehow) customized MSDE are
available at
http://msdn.microsoft.com/library/de...stsql_84xl.asp
just for the case, I've just installed an MSDE named instance on a brand new
WinXP sp 2 machine...
I disabled the antivirus (it was Avast), checked "File & Printer Sharing"
was enabled, the "Server" service was running..
the LAN access was available through the subnetmask exception...
I installed a named instance like
setup.exe INSTANCENAME="MSDE" SAPWD=*** SECURITYMODE=SQL
DISABLENETWORKPROTOCOLS=0 /L*v "C:\MsdeLog.txt"
and that installed a named instance named "MSDE", allowing SQL Server
authenticated connections (mixed authentication), with support for remote
connections and logging the install process to C:\MsdeLog.txt, a text file
of about 2mb you can inspect for toubleshooting problems, searching for
RETURN VALUE 3
entries that denotate errors, where 10/20 lines before and/or after some
(somteime criptic) description of the problem is recoded... thi installation
worked as a charm... :D
after that I configured the Windows firewall defining an exception allowing
acces to the MSDE instance used TCP port and another exception for UDP 1434
port for the SQL Server Service Listener...
in order to configure XP sp2 for SQL Server connectivity you can ahave a
look at http://support.microsoft.com/default.aspx?kbid=841249
regards
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply