sql server msde: I installed with DISABLENETWORKPROTOCOLS=0 but I still cannot connect to the
MSDE named instance using Enterprise Manager

The environment is:
Win XP SP2
Firewall is OFF

hi Karl,
[quoted text, click to view]

DISABLENETWORKPROTOCOLS=0 enables network protocols, thus allowing remote
connections..
is the instance name correct? it must be in the ComputerName\InstaneName
form...
which authentication method are you using?
what kind of exception are youprompted with?
for mixed mode authentication (username + pwd), the instance must be set to
allow this option, tipically at installation time, providing the
SECURITYMODE=SQL
parameter to the setup.exe MSDE boostrap installer, but you can modify it
after installation as described in
http://support.microsoft.com/default.aspx?scid=kb;en-us;285097 in the
"Windows registry hacking" section..
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.19.0 - DbaMgr ver 0.63.0 and further SQL Tools
--------- remove DMO to reply

Just to add to Andrea, make sure that if you are using another port
than the default one (1433) you have to name it after the the
InstanceName in the syntax as: MachineName\InstanceName,Portnumber.

HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---