SQL Server 2012 automated Install ini Feature list

Any DBA worth their salt will have automated the deployment of any version of SQL server using a SQL server configuration ini and a standard installation script. Through the ini, you can manage exactly what you required to be installed, where you want it installed and how you want your features to run.

With the introduction of SQL Server 2012, Microsoft introduced some new features that can be included in your network standard installation, so I figured it was time to update the list of features and their abbreviated name that needs to be included in the ini.

In your ini, you will have a line approximate to this:

FEATURES=SQLENGINE,REPLICATION,FULLTEXT,DQ,AS,RS,RS_SHP,RS_SHPWFE,DQC,BIDS,CONN,IS,BC,SDK,BOL,SSMS,ADV_SSMS,DREPLAY_CTLR,DREPLAY_CLT,SNAC_SDK,MDS

For reference, here are the full names:

Ini
name

Feature

SQLENGINE

SQL
Server Engine

REPLICATION

Replication

FULLTEXT

Full
text Search

DQ

Data
Quality Services

AS

Analysis
Services

RS

Reporting
Services – Native

RS_SHP

Reporting
Services – SharePoint

RS_SHPWFE

Reporting
Services Add-in for SharePoint Productsa

DQC

Data
Quality Client

BIDS

SQL
Server Data Tools

CONN

Client
Tools Connectivity

IS

Integration
Services

BC

Client
Tools Backward Compatibility

SDK

Client
Tools SDK

BOL

Documentation
Components

SSMS

Management
Tools – Basic

ADV_SSMS

Management
Tools – Complete

DREPLAY_CTLR

Distributed
Replay Controller

DREPLAY_CLT

Distributed
Replay Client

SNAC_SDK

SQL
Client Connectivity SDK

MDS

Master
Data Services

I hope this list proves useful in laying out your automated 2012 installs.

Thanks for reading.

Advertisements
This entry was posted in SQL Server and tagged , , , , , . Bookmark the permalink.

6 Responses to SQL Server 2012 automated Install ini Feature list

  1. Michael says:

    Thank you for publishing this. I tried looking all over the place for an explanation of what all the different feature names were in the INI file. You did so perfectly.

  2. Matthias Hoffmann says:

    How to /ACTION=UNINSTALL /FEATURES={all features, not knowing them in advance}

  3. Sky says:

    so helpful to me. Thanks!

  4. Reblogged this on Ibrahim Soliman Blog and commented:
    Good reference to interpret/create SQL installation ini file

  5. Pingback: Automated Script Install of SQL Server 2012 | Tom Talks UC

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