Re: Get list of running SQL servers in a LAN?

From: Yahyaee (myt110_at_yahoo.com)
Date: 07/25/04 

Date: Sat, 24 Jul 2004 15:33:33 -0700

Hi,
Using D6 Enterprise,
I want to get a list of running SQL servers in a LAN in code.
Now, My program is installed on W2K Server & Professional, Win 98 and Win XP
Professional systems and will be upgraded with new version.
I had tried two sample codes that i found in this newsgroup :
First, Calling NetServerEnum, passing SV_TYPE_SQLSERVER as the server type,
(Subject : Re: Listing SQL Servers, Posted by Brian Hollister, 4/13/2004
8:00 AM).
It lists sql servers only on W2k, no WXP or W98. Using WXP, It shows only
name of the computer running it.

Second, Code posted by Vitali Kalinin (Subject : Re: Get list of running SQL
servers in a LAN?, 1/19/2004 5:30 AM). I couldnt run this code, i had added
activeX and comobj to uses list to prevent "CoCreateInstance : undeclared
identifire" error.Now it generates "CLASS_Recordset : undeclared identifire"
error. I dont know if it can list servers in all OSs listed above.

How can i get a list of running SQL servers in a LAN in all of OSs listed
above?

thanks for your suggestions and guidance
best wishes and regards

Relevant Pages

  • Re: MSDE not showing up in SQLDMO.ListAvailableServers
    ... It creates a list of SQL Servers that respond to a broadcast on Port ... It combines these two lists. ... MSDE instance, you can read the registry subkeys under ... Is there something I need to do after installing MSDE ...
    (microsoft.public.sqlserver.connect)
  • Re: MSDE not showing up in SQLDMO.ListAvailableServers
    ... It creates a list of SQL Servers that respond to a broadcast on Port ... It combines these two lists. ... MSDE instance, you can read the registry subkeys under ... Is there something I need to do after installing MSDE ...
    (microsoft.public.sqlserver.msde)
  • Re: MSDE not showing up in SQLDMO.ListAvailableServers
    ... It creates a list of SQL Servers that respond to a broadcast on Port ... It combines these two lists. ... MSDE instance, you can read the registry subkeys under ... Is there something I need to do after installing MSDE ...
    (microsoft.public.sqlserver.tools)
  • Re: Repost: Listing SQL Servers on the network using CF
    ... lists there via a web service, and just returned an arraylist (although you ... "Raj Kumar" wrote in message ... > application is run the first time. ... > that has a list of sql servers on the network(the device will be connected ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: what about: instances of sql
    ... with web and sql servers ... for the lan, ... to connect directly to the sql:1433 on dmz ... In any case, if you have multiple instances on a production> box, you'll want to set an upper memory limit for each. ...
    (microsoft.public.sqlserver.server)