Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
MGouders
Starting Member
30 Posts |
 Posted - 2009-10-05 : 11:54:21
|
| Hi,I am in a need to search for a certain server on the networkI have found two ways to use to searcha) sqlcmd -Lb) WMI => wbemtest => namespace:root\directory\ldap => QUERY:SELECT * FROM ds_ms_sql_sqlserverBoth methods return different resultsPlease elaborate on both methods and also, what other different approaches can be taken to search for sql server(s) on a corporate network?Thank You Very Much |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
gvphubli
Yak Posting Veteran
54 Posts |
Posted - 2009-10-05 : 13:41:29
|
| In both the methods that "MGouders" is using the results might be different due to the previlages under which which they run. Some time WMI has some extra restrictions. And in couple of cases I have seen the SQL instance running has restricted network configuration due to which it will not be exposed.Best method is, after preparing you prepare the list automatically(via network scanning) publish it to the internal user group and get the confirmations.TechnologyYogihttp://gvphubli.blogspot.com/ |
 |
|
|
MGouders
Starting Member
30 Posts |
Posted - 2009-10-05 : 14:23:49
|
| Thanks for the Knowledge Sharingtkizer, can you please elaborate on how to use SMS to locate server instances across a corporate network.gvphubli, thanks for the more detailed respond |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Locating SQL Server Instances on a Network