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.
6  5433 
Hi,
Here is an another way to do it: http://www.codeproject.com/cs/database/LocatingSql.asp
"Michael C" <no****@lol.net> wrote in message
news:4f*********************@news4.srv.hcvlny.cv.n et...
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.
Hi Shiva,
I actually tried that method but it didn't work seem to work for MSDE named
instances for some reason... Oh well, back to the drawing board...
Thanks,
Michael C.
"Shiva" <sh******@online.excite.com> wrote in message
news:uU**************@TK2MSFTNGP11.phx.gbl... Hi,
Here is an another way to do it:
http://www.codeproject.com/cs/database/LocatingSql.asp
"Michael C" <no****@lol.net> wrote in message
news:4f*********************@news4.srv.hcvlny.cv.n et...
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.
http://www.codeproject.com/csharp/CompPickerLib.asp
The best way is to use SQL-DMO.
"Michael C" <no****@lol.net> wrote in message
news:4f*********************@news4.srv.hcvlny.cv.n et... 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.
Even tried that (though I'm a little wary of it since I can't guarantee that
every installation of my app will also have SQL Client Tools installed
also)... It doesn't pick up anything if you disconnect from the network -
even if there are local instances running. Also had some problems with MSDE
named instances with SQL-DMO too. I think SQL Enterprise Manager uses
SQL-DMO, and it doesn't detect named instances automatically either on
server registration.
Strange.
Thanks,
Michael C.
"FusionGuy" <sbearusa32 at em s n dot com (that's msn.com)> wrote in message
news:ud*************@TK2MSFTNGP10.phx.gbl... http://www.codeproject.com/csharp/CompPickerLib.asp
The best way is to use SQL-DMO.
"Michael C" <no****@lol.net> wrote in message
news:4f*********************@news4.srv.hcvlny.cv.n et... 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.
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" <no****@lol.net> skrev i en meddelelse
news:4f*********************@news4.srv.hcvlny.cv.n et... 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.
Thanks, but it like NetServerEnum and the other API functions it doesn't
seem to pick up Named Instances which is what I need.
Thanks
Michael C.
"FusionGuy" <sbearusa32 at em s n dot com (that's msn.com)> wrote in message
news:ud*************@TK2MSFTNGP10.phx.gbl... http://www.codeproject.com/csharp/CompPickerLib.asp
The best way is to use SQL-DMO.
"Michael C" <no****@lol.net> wrote in message
news:4f*********************@news4.srv.hcvlny.cv.n et... 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.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: !!bogus |
last post by:
Hi,
Is it possible to install more than one instance of SQL on the same server?
I am thinking of the SQL that comes with Windows 2003 SBS (Small business)
--
Thank you
Please post only
|
by: Robin Tucker |
last post by:
I'm looking for a simple way of telling (inside a stored procedure) if I'm
currently using MSDE or a full SQL server. Ideally, there is some
pre-defined environment variable that won't cause me...
|
by: stefanPL |
last post by:
Hello,
How to determine, which ports do MS SQL Server instances listen to?
I want to conect to sql server using PHP and I need to know exact port
number. I suspect that my SQL (msde) server...
|
by: grondaia |
last post by:
Here's my situation:
I have an ODBC DSN setup for Timberline Data (An accounting package
that uses pervasive.sql) on my sql box. I set up a linked server using
the supplied timberline odbc...
|
by: Bishman |
last post by:
Can anyone suggest a method of enumerating instances of MSDE 2000 without
using DMO ?
Using C++, MFC, and ADO.
Thanks
|
by: Harkin |
last post by:
So I installed an instance of SQL for an application (WSUS) and all was
well. Having read in many places that I could install multiple instances of
MSDE on the same box, I started the second...
|
by: Michael C |
last post by:
Hi all,
After a lot of research, I've come to some realizations about enumerating
Named Instances of MSDE. NetServerEnum() Win32 API function doesn't work,
SQL-DMO doesn't work, no standard...
|
by: G B |
last post by:
I am using netserverEnum to find out about sql servers
however it doesnt pull my msde sql server.
Does anybody know how to retrieve both sql servers and msde sql servers?
Thanks
vbnetuk
|
by: christof |
last post by:
I've asked on sql.programming, but got no answer:
Is there a way to get all the SQL Server instances with SQL SMO from a
remote computer?
I got few instances on some remote IP and
how to list...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |
