<div>
<a href="http://technet.microsoft.com/en-us/security/cc184924" rel="ugc">http://technet.microsoft.com/en-us/security/cc184924</a><br />
<br />
more advance scanner is Nmap<br />
<a href="http://nmap.org/" rel="ugc">http://nmap.org/</a>
</div>


http://technet.microsoft.com/en-us/security/cc184924 [http://technet.microsoft.com/en-us/security/cc184924]

more advance scanner is Nmap
http://nmap.org/ [http://nmap.org/]

<div>
These look like network scanners, will they give me what I'm looking for as far as inventorying my SQL Server installations?
</div>


These look like network scanners, will they give me what I'm looking for as far as inventorying my SQL Server installations?

<div>
yes, you have to configure them for SQL information only.
</div>


yes, you have to configure them for SQL information only.

<div>
I've never used these tools before.......do you have any documentation on how to configure and/or use them?
</div>


I've never used these tools before.......do you have any documentation on how to configure and/or use them?

<div>
See attached screenshot for MBSA. you just have to put your network and select only for SQL stuff.
</div>


See attached screenshot for MBSA. you just have to put your network and select only for SQL stuff.

MBSA.docx

<div>
<div class="content wysiwyg-content">
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.
</div>
</div>


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.

Need a tool to scan network for SQL Server Instances

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

The Microsoft Server topic includes all of the legacy versions of the operating system, including the Windows NT 3.1, NT 3.5, NT 4.0 and Windows 2000 and Windows Home Server versions.

Microsoft Server OS

IT Administration is the processes and best practices for programming and development, and incorporates methodologies for managing activities and projects. Common methodologies include waterfall, prototyping, iterative and incremental development, spiral development, rapid application development, extreme programming and various types of agile methodology. The life-cycle "model" is a more general term for a category of methodologies, and a software development "process" a more specific term to refer to a specific process chosen by a specific organization.