Sometimes you need to know how many and what instances of

SQL Server running in your organization over Network. You can easily see in

simple steps

There are two options Local Servers and Network Servers.

There are various utilities with

more functionality to achieve the same.

I find some utility as

Quest Discovery Wizard for SQL Server makes it simple to

detect all the SQL Server instances in your organization and monitor your

network for changes. It even helps you find SQL Server instances that native

tools cannot detect.

With Discovery Wizard, you can:

Create an inventory of the databases on your network and the

amount of data they contain

Select databases for consolidation

Review database history, including installation and creation

dates

Find out which SQL Server versions and service packs are deployed

Learn server, instance, and operating system names

See who your end users are