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:


SELECT *
FROM sys.configurations;

The details and default configuration settings can be found at https://msdn.microsoft.com/en-us/library/ms188345(v=sql.105).aspx.

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

Kevin Kline

Career and Technical Advice for the IT Professional

TroubleshootingSQL

Explaining the bits and bytes of SQL Server and Azure

SQL Authority with Pinal Dave

SQL Server Performance Tuning Expert

Powershellshocked

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: