all groups > sql server msde > october 2005 >
You're in the

sql server msde

group:

MSDE and Query Analyzer


Re: MSDE and Query Analyzer Andrea Montanari
10/21/2005 12:00:00 AM
sql server msde:
hi,
[quoted text, click to view]

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

MSDE and Query Analyzer phil1bruening NO[at]SPAM web.de
10/21/2005 6:29:11 AM
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.
Re: MSDE and Query Analyzer phil1bruening NO[at]SPAM web.de
10/24/2005 12:02:37 AM
Thanks, the problem was, that in the TCP/IP configuration
(svrnetcn.exe) was the same port as in the configuration of the
Standard-Instance
AddThis Social Bookmark Button