Connection to MSDE

Hi,
Is it possible to connect to a MSDE engine
from Management Studio 2005 ?
With tcpview, I didn't see a port which it listens
Thanks in advance
hi,
astalavista wrote:
> Hi,
> Is it possible to connect to a MSDE engine
> from Management Studio 2005 ?
> With tcpview, I didn't see a port which it listens
>
yes, you can connect from Management Studio to MSDE database...
MSDE installs by default disabling remote connections and network protocols,
thus tcp/ip protocol is not enable and local connections will be available
via shared memory only...
to enable remote connections and tcp/ip protocol you have to run the Server
Network Utility (svrnecn.exe) and enable the required protocol..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
-- remove DMO to reply
|||Thank you very much ...
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> a crit dans le message de
news: 5ccv2sF30j4u5U1@.mid.individual.net...
> hi,
> astalavista wrote:
> yes, you can connect from Management Studio to MSDE database...
> MSDE installs by default disabling remote connections and network
> protocols, thus tcp/ip protocol is not enable and local connections will
> be available via shared memory only...
> to enable remote connections and tcp/ip protocol you have to run the
> Server Network Utility (svrnecn.exe) and enable the required protocol..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz http://italy.mvps.org
> DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
> -- remove DMO to reply
>