Connection Problem - MSDE 2000 on Peer to Peer Network

I have MSDE installed on one of my computers in my peer to peer network (all
computers XP Professional). All computers on the network can see each
other. However, I cannot use Query Analyzer or Enterprise Manager to
connect to MSDE except from the computer that contains MSDE.
Is it possible to connect to MSDE using Query Analyzer etc, in this
scenario.
ThanksI'll be honest, I have yet to work with MSDE but here are some links that
may help
http://support.microsoft.com/defaul...kb;en-us;319930
http://support.microsoft.com/defaul...kb;en-us;325003
HTH
Ray Higdon MCSE, MCDBA, CCNA
--
"Sid Sarin" <sidsarin123@.earthlink.net> wrote in message
news:zByYb.9378$W74.78@.newsread1.news.atl.earthlink.net...
> I have MSDE installed on one of my computers in my peer to peer network
(all
> computers XP Professional). All computers on the network can see each
> other. However, I cannot use Query Analyzer or Enterprise Manager to
> connect to MSDE except from the computer that contains MSDE.
> Is it possible to connect to MSDE using Query Analyzer etc, in this
> scenario.
> Thanks
>|||By default, MSDE 2000 SP3 only has shared memory (LPC) enabled. To allow
connections from remote machines you have to enable TCP and/or named pipes
through the server network utility (svrnetcn.exe).
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.