January 7, 2006 at 3:19 am
Hi,
I want to know how can i know the number of installed sql server over the network.
Client and EM
Thanx
Killer
January 7, 2006 at 7:46 am
You want to know who has installed the tools, who has SQL Server itself installed, or both?
The easiest way is with asset management software like Altiris or SMS. There are no automated tools to get who has installed the tools. However, you can determine SQL Server installs by using a tool like SQLRecon. See more in the thread here:
Discoverying Illegal 2005 Installs?
K. Brian Kelley
@kbriankelley
January 8, 2006 at 8:03 pm
Dear,
I want to know the name of the network computers having installed sql server.(Sql Server2000)
thanx
from
sufian
January 9, 2006 at 7:01 am
SQLRecon performs the name resolution after it searches and finds SQL Servers based on IP.
K. Brian Kelley
@kbriankelley
January 10, 2006 at 1:00 am
Hi Brain,
Thanx for u help
I did it like this
exec xp_cmdshell 'osql.exe -L >C:\log.txt'
from
Killer
January 10, 2006 at 7:02 am
You can do that, but that command will miss SQL Servers if any of the following is true:
1) a SQL Server is installed on a system but not started
2) a SQL Server is configured to hide itself
3) an IPSEC policy is in place on a system where SQL Server is installed to block traffic to/from udp/1434
A tool like SQLRecon will use all known methods of discovering SQL Server including checking a computer's services and the registry. This is something osql.exe -L, which merely lists any SQL Servers responding to broadcasts, cannot do. Therefore, more often than not, osql.exe -L does not give you a complete list of SQL Servers on your network.
K. Brian Kelley
@kbriankelley
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply