About
Blog
Abbreviations for SQL Server Components when Installing with PowerShell

Abbreviations for SQL Server Components when Installing with PowerShell

SQL Server Component Install Options

I have (finally) been introduced to installing SQL Server with PowerShell and it has made those installations much easier. Each of my installs; however, may require different SQL Server components so one of the items in my configuration file I change is the Features= section of the INI file. To help keep all this information in one place, here is a list of items you can choose to install. Remember, most of these will require other parameters to be set–this is only for the Features= section. Each feature should be separated by a comma.

This list specifies the items you can choose to install.

Database engine = SQLENGINE
Replication = REPLICATION
Full-text and semantic extractions for search = FULLTEXT
Data quality services = DQ
Analysis services = AS
Reporting services – native = RS
Reporting services – sharepoint = RS_SHP
Reporting services add-in for sharepoint products = RS_SHPWFE
Data quality client = DQC
SQL Server data tools = BIDS
Client tools connectivity = CONN
Integration services = IS
Client tools backwards compatibility = BC
Client tools SDK = SDK
Documentation components = BOL
Management tools – basic = SSMS
Management tools – advanced = ADV_SSMS
Distributed replay controller = DREPLAY_CTLR
Distributed replay client = DREPLAY_CLT
SQL client connectivity SDK = SNAC_SDK
Master data services = MDS

Happy installing. 🙂

Carlos Chacon

Director of Data Solutions

With more than 10 years of working with SQL Server, Carlos helps businesses ensure their SQL Server environments meet their users’ expectations. He can provide insights on performance, migrations, and disaster recovery. He is also active in the SQL Server community and regularly speaks at user group meetings and conferences. He helps support the free database monitoring tool found at databasehealth.com and provides training through SQL Trail events.