finding an SQL server
-
Does anyone know of a programmatic way of finding which server(s) may be running, so a new client installation can be provided with a drop-down list of where the data may be held? There will be a defined instance in each case, so all servers to be found will be of the form "machinename\myinstance" - I just need to find possible values for 'machinename'. (pretty much like the facility in Enterprise Manager for finding a new server registration). We are using C# (.NET 2003) but I can translate from other methods if required.
-
Does anyone know of a programmatic way of finding which server(s) may be running, so a new client installation can be provided with a drop-down list of where the data may be held? There will be a defined instance in each case, so all servers to be found will be of the form "machinename\myinstance" - I just need to find possible values for 'machinename'. (pretty much like the facility in Enterprise Manager for finding a new server registration). We are using C# (.NET 2003) but I can translate from other methods if required.
Next time try searching Google *and* CodeProject first, since there are many good articles. http://www.codeproject.com/cs/database/LocatingSql.asp[^] Good luck! :) -- LuisR
Luis Alonso Ramos Intelectix - Chihuahua, Mexico Not much here: My CP Blog!
-
Next time try searching Google *and* CodeProject first, since there are many good articles. http://www.codeproject.com/cs/database/LocatingSql.asp[^] Good luck! :) -- LuisR
Luis Alonso Ramos Intelectix - Chihuahua, Mexico Not much here: My CP Blog!
-
Many thanks Luis. This looks perfect. And it seems I need to keep up with the times, Google is getting good for this sort of thing.
You're welcome. I'm glad I could help! :) Google is really awesome. I've seen that 95% in less than 2 minutes I find what I'm looking for. And here in CP you can find many articles about almost everything! -- LuisR
Luis Alonso Ramos Intelectix - Chihuahua, Mexico Not much here: My CP Blog!