How to install SSRS (SQL Server Reporting Service) 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.

  • 0 Users Found This Useful

Was this answer helpful?

Related Articles

How to create a Database (Asp .net or Other) on MSSQL Server?

If you have a Windows VPS / Dedicated server with MSSQL Server and WebsitePanel installed, you...

How to Shrink Transaction Logs of Database in MS SQL?

This article will assist you to shrink/truncate the transaction logs of database in MS SQL...

Do you offer SQL schedule job?

Windows Shared HostingWe do not offer SQL server schedule job in our Windows shared hosting...

How to fix "Upgrade Error - Valid Database compatibility level and successful connection rule"?

One of our Windows VPS customers wanted to upgrade SQL Server from SQL Server 2008 R2 to SQL...

How to Increase the MS SQL Remote Query Timeout?

MS SQL Server has an option called Remote Query Timeout to specify the time (in seconds), a...