sql server msde:
hi,
[quoted text, click to view] phil1bruening@web.de wrote:
> Hi,
> I have installed 2 Instances of SQL Server 2000 and a MSDE Instance on
> a Server (only for testing). I have connect the Query Analyzer and the
> Enterpise Manager with the 3 Instances (always on the server). Then i
> wanted to connect a client ( the Query Analyzer and the Enterpise
> Manager of this client) with the Instances. With the instances of
> SQLServer 2000 it goes but not with the MSDE. Why does it not go with
> the MSDE? Can anybody help me? Thanks.
MSDE installs by default disabling network protocols for security
reasons...
you can modify this behaviour both at install time, providing the
DISABLENETWORKPROTOCOLS=0
parameter to the setup.exe boostrap installer of MSDE, or later, at
"run-time", running the Server Network Utility (svrnetcn.exe) and enabling
the required/desired network protocol..
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply