- Go to SSMS.
- Object Explorer
- Click on Connect
- Go to Server Name Dropdown and Select Browse for More
- Local Servers: It lists all instances installed on your local machine.
- Network Servers: It lists all instances installed on your Network.
Daily SQL Articles by email:
Get Your Own Blog
If you would like to blog on SQLServerCentral.com then send an email to firstname.lastname@example.org.
Contact the author
Archives for this blog
I am a technology enthusiast and software developer by profession. I am developing .Net/database based enterprise applications from past 3 years.
My skills includes C# ,ASP.NET,SQL Server 2008 and MVC . My areas of interests are database development and application software development using Microsoft Technologies.
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
The Microsoft Assessment and Planning Toolkit make it easy to assess your current IT infrastructure for a variety of technology migration projects. This Solution Accelerator provides a powerful inventory, assessment, and reporting tool to simplify the migration planning process.