Improve company productivity with a Business Account.Sign Up

x
?
Solved

Need a tool to scan network for SQL Server Instances

Posted on 2012-04-02
7
Medium Priority
?
809 Views
Last Modified: 2012-06-08
Can anyone recommend a tool (preferably a free one) that I can use to scan the network for installed instances of MS SQL Server? Specifically, I'm looking for a tool that can differentiate between the different versions of SQL such as MSDE, SQL Express, 2000, 2005, and 2008. If it could give me the service pack level that would be a nice bonus as well. Thanks.
0
Comment
Question by:mcpp661
  • 4
  • 3
7 Comments
 
LVL 17

Expert Comment

by:Anuroopsundd
ID: 37796977
0
 

Author Comment

by:mcpp661
ID: 37797006
These look like network scanners, will they give me what I'm looking for as far as inventorying my SQL Server installations?
0
 
LVL 17

Expert Comment

by:Anuroopsundd
ID: 37797019
yes, you have to configure them for SQL information only.
0
NEW Internet Security Report Now Available!

WatchGuard’s Threat Lab is a group of dedicated threat researchers committed to helping you stay ahead of the bad guys by providing in-depth analysis of the top security threats to your network.  Check out this quarters report on the threats that shook the industry in Q4 2017.

 

Author Comment

by:mcpp661
ID: 37797049
I've never used these tools before.......do you have any documentation on how to configure and/or use them?
0
 
LVL 17

Expert Comment

by:Anuroopsundd
ID: 37797092
See attached screenshot for MBSA. you just have to put your network and select only for SQL stuff.
0
 

Author Comment

by:mcpp661
ID: 37798767
There's no screenshot.
0
 
LVL 17

Accepted Solution

by:
Anuroopsundd earned 1500 total points
ID: 37798785
sorry missed it earlier.
MBSA.docx
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

SingleRun is a tool that ensures that only one instance of an application is started, running it again brings the application to focus.
As the cloud has become an integral part of enterprises’ workflow worldwide, there is an increasing demand for cloud managed service providers that can bring the expertise to the process and help enterprises maximize their investment in the cloud.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question