ListAvailableSQLServers, local network segment?, network-visible server? 
Author Message
 ListAvailableSQLServers, local network segment?, network-visible server?

When I run command osql -L I don't see a complete list of
all SQL servers which are running. The ones which are
being not shown in the output can be connected via OSQL.
Does anyone have a clue why doesn't OSQL -L command yield
those non-visible servers.

The same behaviour is exhibited by ListAvailableSQLServers
method of application object in SQLDMO. MSDN online
mentions, "The ListAvailableSQLServers method returns a
NameList object that enumerates network-visible instances
of Microsoft? SQL ServerT 2000." Please note the word
network-visible. Does anyone have a clue how to make an
existing server visible on the network? Is it possible or
not?

Go to the the link on
http://www.***.com/
scid=kb;en-us;Q287737

It uses the phrase local network segment. It mentions, "By
using SQL Server Distributed Management Objects (SQLDMO),
all running SQL Servers on a local network segment can be
listed."

What's a local network segment? Is it possible for SQL
server instance to be seen by other network segements? If
yes, then how? I hope some setting is there in SQL Server
or some other workaround?

Thanks and regards



Sat, 25 Dec 2004 15:09:18 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Can't install SQL Server on local machine - No server in Network Neighborhood

2. using DTS to transfer file from one server to another on same network segment

3. how to use get the name of SQL server withion a local network

4. connect to SQL server from win95 / local network ???

5. Retreive SQL Servers on Local Network

6. Retreive SQL servers on Local Network

7. Cannot connect to local SQL server while not connected to network

8. Relative Newbie, Moving DB's from Network Server to Local

9. SQL Server access on Novell network without Client for MS Networks

10. Cannot connect to local SQL server while not connected to network

11. Unable top Connect to Local SQL Server 6.5 database - keeps brining up dial up networking

12. local network server mirror


 
Powered by phpBB® Forum Software