Monday, September 23, 2013

How to find out installed features on SQL server instance

The SQL Server Setup Discovery Report helps to view installed features on a local SQL server instance,

Start menu --> All Programs --> Microsoft SQL Server --> Configuration Tools --> SQL Server Installation Center --> Click the "Tools" --> "Installed SQL Server features discovery report"



The command line version would be like the folowing:
setup.exe /ACTION=RUNDISCOVERY /Q

The setup.exe is located somewhere like (for MS SQL Server 2012):
C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\SQLServer2012

The report will be located in log folder under "Setup Bootstrap" in a unique subfolder which will be named as YYYYMMDD_HHmmSS, but the location can be vary depend on installation location:
C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\YYYYMMDD_HHmmSS

Share/Bookmark

No comments: