Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is there a place within a current SQL server 2008 installation that can I see which instance and shared features are installed?

share|improve this question
up vote 1 down vote accepted

Doesn't SQL Server Configuration Manager show most of the details you require?

share|improve this answer
+1 Configuration Manager will show you all of your instances and the services installed. If you don't find Config Manager in the start menu (happens) you can add it as a snap-in to MMC. If you have multiple versions of SQL on your box (ie- 2005, 2008, etc) use the Configuration Manager from the highest version to see them all. – squillman Jul 9 '10 at 16:49

Use SQL Server features discovery report tool in SQL Server Installation Center.

share|improve this answer

Facets under Mgt Studio should cover everything else beyond configuration manager that you are wanting to know about your SQL 2008 install (Mgt Studio...Object Explorer...Right click ServerName...Facets).

share|improve this answer
+1 here also. Wish they had put this in 2005... – squillman Jul 9 '10 at 16:55

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.