Determine SQL Server Features And Configurations

Aim: Determine which SQL Server Features are installed and configuration settings.

To determine which features are installed on a server, run the Discovery Report which is available on SQL Server 2008 onwards.

Navigate to the SQL Server Configuration Tools folder in the Windows Start menu and launch the Installation Centre.

1 Installation Centre

In Tools, click Installed SQL Server features discovery report to launch the Discovery Report.

2 Launch Report

The Discovery Report will show installed features, editions, versions & other information.

3 Discovery Report

A copy of the report can also be found in the SQL Server Program Files folder, e.g. C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\<yyyymmdd_hhmmss>.

To find further configuration information for an particular instance, run the following query:

FROM sys.configurations;

The details and default configuration settings can be found at


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

Kevin Kline

Career and Technical Advice for the IT Professional


Explaining the bits and bytes of SQL Server and Azure

SQL Authority with Pinal Dave

SQL Server Performance Tuning Expert


A blog about PowerShell and general Windows sysadmin stuff

Simon Learning SQL Server

I'm trying to become "better" at SQL Server and data - here's how I'm doing it!

%d bloggers like this: