How to find available SQL Server on local network

[ashishraj14]

Using VB.NET how can I find all available SQL Server on a local network and list all the databases in each server.

 

[chrissie1]

this is one that comes back from time to time and can be easily found with a search on google or this forum.

The only problem is that most solutions only work when service pack 3 is installed on the server.

Christiaan Baes
Belgium

If you want to get an answer read this FAQ faq796-2540
There's no such thing as a winnable war - Sting

 

[chrissie1]

I did some searching and found this that will help

thread796-813241
thread796-844885

Christiaan Baes
Belgium

If you want to get an answer read this FAQ faq796-2540
There's no such thing as a winnable war - Sting

 

[ashishraj14]

thanks chrissie, i did some search but couldn't find anything. thanks for the links

 

[ca8msm]

If you did a search and didn't find anything you may want to look at the keywords you are using as searching for "SQL Server Network" found both the links that chrissie provided.

--------------------------------------------------------------------------------------------------------------------------------------------

Need help finding an answer?

Try the search facility (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.

 

[ashishraj14]

I am getting the following error

QueryInterface for interface SQLDMO.NameList failed.

???

 

[ashishraj14]

additional information

I am running it on WIN2k

 

[ashishraj14]

Installing latest SP fixed the problem.

Have another issue though

I installed sql server on stand alone machine, running XP. The code doesn’t generate any error, but doesn’t show the instance of sql server installed on it. Does the method ListAvailableSQLServers scan the network for instances of sql server, not the local machine?