Re: MSDE not showing up in SQLDMO.ListAvailableServers

From: Michael C (michaelc_at_nospam.org)
Date: 07/29/04 

Date: Thu, 29 Jul 2004 19:33:40 GMT

I had the same problem. SQL-DMO does two things when it enumerates SQL
Servers:

1. It creates a list of SQL Servers using the Win32 API NetServerEnum
function
2. It creates a list of SQL Servers that respond to a broadcast on Port
1433
3. It combines these two lists.

If you're not connected to a network, NetServerEnum doesn't seem to return
any SQL Servers. MSDE runs on Port 1434 instead of 1433, which means it
won't pick up the broadcast. If you're just trying to enumerate the LOCAL
MSDE instance(s), you can read the registry subkeys under
HKLM\Software\Microsoft\MSSQLServer\MSSQLServer and
HKLM\Software\Microsoft\Microsoft SQL Server.

If anyone out there knows of a function that can be used to return named
instances of MSDE, I'd appreciate the info.

Thanks,
Michael C.

"Dave Taylor" <nospam_dave@processeng.com> wrote in message
news:OtXGtZZdEHA.3944@tk2msftngp13.phx.gbl...
> I have a VB.NET app using MSDE and the SQL-DMO to get a list of available
> server. I installed a copy of MSDE on the users' machine (this machine
did
> not have MSDE previously so it was a new copy including latest SP3), then
> installed my app. When I start my app, the local computer name does not
> show up in the list of available servers. This has happened twice now on
> separate machines. Is there something I need to do after installing MSDE
> for it to register as a server? Note: I know MSDE is installed and
running
> because my app creates and properly fills databases on the local machine,
it
> just doesnt show up in the list of available servers.
>
> Thanks
>
> Dave Taylor
>
>

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.tools)
  • Re: Get list of running SQL servers in a LAN?
    ... I want to get a list of running SQL servers in a LAN in code. ... It lists sql servers only on W2k, ...
    (borland.public.delphi.database.ado)
  • 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: Why cant I browse my servers in the IDE?
    ... MSDE 2000 SP3 for VS.Net ... It is not just the SQL servers that I can not see, ... >If Mr. Jason tries to have the new SQL Server versions in his system, i think the problem will be solved. ... > My MSDE service is running fine. ...
    (microsoft.public.dotnet.general)
Loading