Re: MSDE not showing up in SQLDMO.ListAvailableServers
From: Michael C (michaelc_at_nospam.org)
Date: 07/29/04
- Next message: Andrea Montanari: "Re: MSDE not showing up in SQLDMO.ListAvailableServers"
- Previous message: Dave Taylor: "Re: MSDE not showing up in SQLDMO.ListAvailableServers"
- In reply to: Dave Taylor: "Re: MSDE not showing up in SQLDMO.ListAvailableServers"
- Next in thread: Andrea Montanari: "Re: MSDE not showing up in SQLDMO.ListAvailableServers"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 29 Jul 2004 20:16:01 GMT
No problem. I just found a website that has a utility for retrieving all
SQL Server information from all computers on a specified subnet via a UDP
packet sent to Port 1434. I tested it on my home network (I don't have MSDE
installed right now though). It might be another way to go... but right
now I'm not sure if it's robust enough for my purposes. Anyway, here's the
link http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=26. (One version
includes C# source code). If you do try the SQLPing utility, please let me
know if it returns MSDE info. also.
Enjoy,
Michael C.
"Dave Taylor" <nospam_dave@processeng.com> wrote in message
news:%234E8NcadEHA.3392@tk2msftngp13.phx.gbl...
> Michael,
>
> Thanks for the reply and info. At least now I know it isn't something I
was
> doing wrong.
>
> I'll use your registry workaround for the local info.
>
> Thanks again
>
> Dave Taylor
>
> "Michael C" <michaelc@nospam.org> wrote in message
> news:oicOc.19466$oE1.1984378@news4.srv.hcvlny.cv.net...
> > 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
> > >
> > >
> >
> >
>
>
- Next message: Andrea Montanari: "Re: MSDE not showing up in SQLDMO.ListAvailableServers"
- Previous message: Dave Taylor: "Re: MSDE not showing up in SQLDMO.ListAvailableServers"
- In reply to: Dave Taylor: "Re: MSDE not showing up in SQLDMO.ListAvailableServers"
- Next in thread: Andrea Montanari: "Re: MSDE not showing up in SQLDMO.ListAvailableServers"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
