Problems with MSDE

[Markus Graf]

Hi all

I'v got a Windows XP Pro SP1 Box with MSDE sql2k SP3. The installation
was not the problem, but if i would connect with a client like dbamgr2k
or the MS Enterprise client, the client hangs up. If i try a nonlocal
server, it hangs too. What's the problem?

Markus

[Andrea Montanari]

hi Markus,
"Markus Graf" <gu***@bluewin. ch> ha scritto nel messaggio
news:2u******** *****@uni-berlin.de

Hi all

I'v got a Windows XP Pro SP1 Box with MSDE sql2k SP3. The installation
was not the problem, but if i would connect with a client like
dbamgr2k or the MS Enterprise client, the client hangs up. If i try a
nonlocal server, it hangs too. What's the problem?

Markus

MSDE installs by default disabling the network protocols, thus only local
connections are enabled... in order to allow remote connections, you have to
re-enable them, running the Server Network Utility (svrnetcn.exe). .. restart
the service...
to enable network protocols at install time, you have to provide the
DISABLENETWORKP ROTOCOLS=0
parameter to the setup.exe bootstrap installer of MSDE

on WinNT platforms MSDE installs by default allowing only truste
connections, thus SQL Server authenticated connections (providing Username
and Password) are not allowed.. in order t change this behaviour, you have
to modify the Windows registry as explained in
http://support.microsoft.com/default...b;en-us;285097
--
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