Friday, 20 March 2015

How many way to find running SQL Server Instance on Server?

Six way to find how many instance are running on your Server.

  1. SQL Server Configuration Manager
  2.    Services. Msc
  3.   SQL CMD
  4.  Detailed file
  5.  Summary.txt
  6. Discovery Report

1) SQL Server Configuration Manager







2) Services. MSc
Type services. Msc in run and enter
















3 ) SQL CMD












4) Detailed file
C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20150317_225942















5) Summary.txt

C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log















6) Discovery Report
This most interesting way to find instance and edition just go your SQL Server Setup media and click on setup.exe and click on the tool and select Installed "SQL Server feature discovery" option



















Please let me know if any other way as well if i miss anyone here :)





No comments:

Post a Comment