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

sql server msde

group:

Install MSDE But Not Connect from Other machine


Install MSDE But Not Connect from Other machine Syed Khurram Alam
9/22/2005 12:00:00 AM
sql server msde:
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

Re: Install MSDE But Not Connect from Other machine Andrea Montanari
9/22/2005 12:00:00 AM
hi,
[quoted text, click to view]

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.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

AddThis Social Bookmark Button