Re: Enumerating Named Instances of SQL Server/MSDE

From: Benny Tordrup (nospam)
Date: 07/20/04


Date: Tue, 20 Jul 2004 10:39:13 +0200

Michael, se my posting in the thread
Re: Get all sql servers on network from dot net app.. sqldmo or reflection

in microsoft.public.sqlserver.programming

"Michael C" <nospam@lol.net> skrev i en meddelelse
news:4fiKc.31909$Kz3.3077912@news4.srv.hcvlny.cv.net...
> Hi all,
>
> I am currently using a Win32 API call to NetServerEnum to enumerate all
SQL
> Servers on an NT Domain. The function returns the names of all servers
> running SQL Server on the network, but it doesn't return any SQL
Server/MSDE
> named instances. Does anyone have any ideas on how to enumerate all named
> instances of SQL Server/MSDE on a Domain as well as the default instances?
>
> Thanks,
> Michael C.
>
>



Relevant Pages

  • Re: Cannot login SQL Server with sa
    ... I check my other two SQL Servers, ... > Hi Kai, ... error code 18452 suggests SQL Authentication is not ... > Michael Cheng ...
    (microsoft.public.sqlserver.security)
  • Re: "Reinigung" einer grossen Datenbank
    ... von Michael wuerde ich gerne wissen, ob er es denn probiert hat. ... Alleine schon die Lernkurve bzgl. des SQL Servers rechtfertigt für das vorgestellte Problem nicht. ... Er hat nämlich keine Probleme bzgl. mangelnder Geschwindigkeit oder zu geringem SQL-Sprachumfang, oder dass er eine echte Client-Server-DB bräuchte. ...
    (microsoft.public.de.access)
  • List SQL servers in a network
    ... Most of the solutions use SQLDMO to list all sql servers in the network like ... public static string[] GetAvailableSQLServers ... - this does not work with Windows XP (see SQLDMO documentation: ...
    (microsoft.public.dotnet.general)
  • Remote connection errors
    ... When trying to connect to 2 of my SQL Servers I am getting General Network ... SQLState: 08S01 Native Error: 11 ...
    (microsoft.public.sqlserver.connect)
  • Need help On NTBACKUP
    ... Happy X-mas ans holidays ... i have 3 sql servers in my network. ...
    (microsoft.public.windows.server.general)