How to Install Advanced Features on Existing Instance of MS SQL Server?

If you have chosen MS SQL Server to be installed in Windows VPS while placing an order, you'll get pre-installed MS SQL server along with Advanced Services. MS SQL Server Advanced services include excellent features like, Full Text search, Reporting service, Advanced query optimizer, Triggers, Stored procedures, Views, etc.

This article will help those who've installed MS SQL Server without Advanced Features, and they wish to add them on existing MS SQL Server instance.

Note that, when you follow this knowledge-base, it is assumed that you have pre-installed MS SQL Server 2012 instance without Advanced Services.

  1. For MS SQL Server 2012, download the setup file SQLEXPRADV_x64_ENU.exe with Advanced ServicesFor MS SQL Server 2008, download the installer file SQLEXPRADV_x64_ENU.exe with Advanced Services.

    To match the pre-installed MS SQL Server version, we have selected 64 bit version installer. You should choose the installer version according to your existing setup. If required, you may also choose other additional components (SQL Server Management Studio, etc.) to be installed with setup files.

  2. Once necessary setup files are downloaded, launch the installation process and you would see following screen. Select first option New SQL Server stand-alone installtion or add features to an existing installation.

    Select New Installtion or Add Features to an Existing Installation Option

  3. At this stage, installer will run several rule checks and you would see several installation progress bars.

    Add Features

    install Setups

    Rule Check


  4. On the Installation Type screen, select Add features to an existing instance of SQL server 2012 option and click on Next button to proceed.

    Add Features


  5. On the Feature Selection screen, select the advanced features you want to install on existing MS SQL Server instance and click on Next button to proceed. Again, installer will run some installation rule checks and disk space requirements check.

    Feature Selection

  6. On the Server Configuration screen, you may configure an account for each SQL service, or you can simply skip it by clicking the Next button.

    Server configuration

  7. On the Reporting Service Configuration screen, select Install only option and click on Next button. Since Reporting Service is not installed yet, you may need to configure it later on.

    Reporting Service Configuration

  8. On the Error Reporting screen, simply click on Next button.

    Error Reporting

  9. On the next window, you would see installation progress as follows.

    installation Progress
  10. Once selected components are installed, you would see following success message.

    Setup Completion



  • 0 Users Found This Useful

Was this answer helpful?

Related Articles

How do I connect to MSSQL Server 2012 from SQL Server Management Studio?

This article will guide you on how to connect to MS SQL Server 2012 from SQL Server Management...

How to assign particular permissions to SQL server database user from SQL Server Management Studio?

We can restrict SQL database users to fire some critical queries, e.g. Update, Delete, etc....

How to fix an error "change password failed for login sa"?

Sometimes you receive following error while trying to reset MS SQL sa password via SQL Management...

Fix - Microsoft SQL Server, error: 10053 - An established connection was aborted by the software in your host machine

One of our Windows VPS customers received following error while connecting to MS SQL server....

How to install MS SQL Server 2016?

Microsoft® SQL Server® 2016 is the latest version of Microsoft's relational database management...