Installation question

Hi,
I have MSDE (SQL server) running various workstations within my home
network. I have no problem connecting to the SQL server instance on
each local machine but when I try to connect to a SQL server on one of
the other workstations I get errors indicating that the Server cannot
be found. However, if I use Widows XP ODBC manager I can create a
system DSN that passes the connection test.
Was I supposed to do something to allow SQL server to be used by other
workstations?
Thanks
hi,
ZRexRider wrote:
> Hi,
> I have MSDE (SQL server) running various workstations within my home
> network. I have no problem connecting to the SQL server instance on
> each local machine but when I try to connect to a SQL server on one of
> the other workstations I get errors indicating that the Server cannot
> be found. However, if I use Widows XP ODBC manager I can create a
> system DSN that passes the connection test.
> Was I supposed to do something to allow SQL server to be used by other
> workstations?
> Thanks
please verify each MSDE instance, on each computer, has the required/desired
network protocols enabled..
use the Server Network Utility (svrnetcn.exe)
MSDE installs by default disabling network protocols, but you can override
this setting at install time specifying the
DISABLENETWORKPROTOCOLS=0
parameter to the setup.exe boostrap installer..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply