Install MSDE But Not Connect from Other machine

Hi all
i install microsoft MSDE on one machine it work fine on that machine but
when i am trying to connect from other machine by giving osql -U
"Username" -S "ServerName" and password but it give me error message Sql
server does not exist"
and when i try to connect from Sql server Query Analyzer it also give me
error message
please help me
thanks in advanced
Regards
khurram
hi,
Syed Khurram Alam wrote:
> Hi all
> i install microsoft MSDE on one machine it work fine on that machine
> but when i am trying to connect from other machine by giving osql -U
> "Username" -S "ServerName" and password but it give me error message
> Sql server does not exist"
> and when i try to connect from Sql server Query Analyzer it also give
> me error message
MSDE installs by default disabling network protocols to help users maintain
a secure instance, and thus allowing only local connections...
you can override that feature at install time providing the
DISABLENETWORKPROTOCOLS=0
parameter to the setup.exe boostrap installer and later, running the Server
Network Utility (svrnetcn.exe) and enabling the desired network
protocol(s)...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://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

Instalation MSDE

When I execute the following instruction
OSQL /USA /P
presents the following error message:
[Microsoft]{ODBC SQL Server Driver][SHARED MEMORY]
SQL Server does not exist or access denied.
[Microsoft]{ODBC SQL Server Driver] Connectionopen
(connect())
Operating system WINDOWS 98 2 Edition
When I verify in the configurations / Panel of Control appeared a new icon
(MSDTC don't remind the acronym). When I execute and requested that selects
the service in what doesn't appear noneEither sa has a non-null password or MSDE is not installed as the default
instance. Use osql /l to list the available servers.
--
Jacco Schalkwijk MCDBA, MCSD, MCSE
Database Administrator
Eurostop Ltd.
"Frank Dulk" <fdulk@.bol.com.br> wrote in message
news:#YYYXxFTDHA.1324@.TK2MSFTNGP11.phx.gbl...
> When I execute the following instruction
> OSQL /USA /P
> presents the following error message:
> [Microsoft]{ODBC SQL Server Driver][SHARED MEMORY]
> SQL Server does not exist or access denied.
> [Microsoft]{ODBC SQL Server Driver] Connectionopen
> (connect())
> Operating system WINDOWS 98 2 Edition
> When I verify in the configurations / Panel of Control appeared a new icon
> (MSDTC don't remind the acronym). When I execute and requested that
selects
> the service in what doesn't appear none
>