1. Home
  2. /
  3. Docs
  4. /
  5. SQL Server
  6. /
  7. Installation & config...
  8. /
  9. What components do I need to...

Which components should I select during installation?

Which components should I select during installation?

For a standard SQL Server database installation, choose Database Engine Services. Select additional components only if your application requires them. Be sure to follow your software vendor’s installation instructions.

What are the different components used for?

Section When should you choose this option?
Database Engine Services For storing, processing, and securing SQL databases. This is the foundation for a standard database installation.
Full-Text and Semantic Extractions for Search When your application uses full-text searches or related search functions.
SQL Server Replication When you set up a replication solution between databases.
Analysis Services For analytical data models and specific BI solutions.
Integration Services For SSIS packages that import, process, and move data.
PolyBase When your solution accesses external data sources via PolyBase.
Machine Learning Services / Language Extensions When your application requires these programming and analysis functions.

The available components and names vary by SQL Server version and edition.

Do I have to check all the boxes?

No. Choose a basic installation of Database Engine Services and add the components required by your application. Installing the full list isn’t necessary for every database.

Where can I find the management program?

You must install SQL Server Management Studio (SSMS) separately. This tool allows you to manage the database engine. Follow the genuine Microsoft instructions for SSMS.

Can I add items later?

Yes, you can add many components later by restarting SQL Server Setup and selecting the option to add features to an existing installation. Afterward, verify that the added components have the correct updates.

Need help choosing the right product?

Email your order number, SQL Server version and edition, and the name of your application to info@cd-keys.uk, or use the contact page. If necessary, include a screenshot of the “Feature Selection” screen.