How to install SQL Server Reporting Service (SSRS) on MSSQL 2014 Express Edition?

SQL Server Reporting Services is used for creating, publishing, and managing reports, and delivering reports to end users in various ways, whether that's viewing them in the browser, on cell phones, or as an email in their inbox.

Generally, SSRS will be pre-installed with the SQL Server Installation, but the several times it is required to install the SSRS separately. Following are the steps to install SSRS on your existing SQL Server 2014 Express Edition

  1. Download the Stand-alone SQL Server Package from Microsoft Website and run it and then click on New SQL Server stand-alone installation or add features to an existing installation.

    stand alone instllation

  2. Select add features to an existing instance of SQL Server and click Next.



  3. Tick the Reporting services -Native in feature selection and click on the Next.

    Reporting service selection
  4. Keep the startup type automatic and click on Next. Here, you can set the Password for the SSRS account.

    startup automatic

  5. Select the Install only in the configuration page and click on Next.

  6. At below screen, you can verify your selected feature installed successfully.

    verify reporting service

        Click on the close button to close the setup for SQL 2014 Installation.

        Looking to verify your existing MSSQL Edition. Please refer to MSSQL > Check Edition for more details.

Related Articles

Unable to launch SQL Server Configuration Manager – Invalid class [0x80041010]

You may receive the below image while you access the server configuration manager on your windows...

Fix : Server Unable to load user-specified certificate. The server will not accept a connection

You may encounter this error when you attempt to start the MSSQL service. This error occurs when...

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...

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...

vs shell installation has failed with exit code 1638.

You may receive the following error while installing MSSQL 2017 on Windows 2012 R2 Server. vs...

  • 0 Users Found This Useful

Was this answer helpful?