Install SQL Server 2014: SSRS Installation

Microsoft SQL ServerIn this small series of posts I’m going to take a step through the installation of SQL Server 2014 and SSRS (the series index can be found at the bottom of each post).

In the previous post I covered the installation of SQL Server itself; in this post I’m going to cover the installation of SSRS. While it is possible to have SSRS installed and configured automatically when SQL Server is installed, but I have experienced problems with SSRS when doing this so I usually install it separately. You would also do a separate installation of SSRS if you had a reporting server where you were doing an install of SSRS.

To install SSRS launch the setup.exe on the installation media, click on Installation in the navigation pane and then click on New SQL Server stand-alone installation or add features to an existing installation:

SQL Server Installation Center

Enter your Product Key and click Next:

SQL Server 2014 Setup - Product Key

Accept the license terms and click Next:

SQL Server 2014 Setup - License Terms

Decide whether to use Microsoft Update and then click Next:

SQL Server 2014 Setup - Microsoft Update

Select SQL Server Feature Installation and click Next:

SQL Server 2014 Setup - Setup Role

In the list of features, mark Reporting Serviuces – Native and then click Next:

SQL Server 2014 Setup - Feature Selection

Like SQL Server itself I am installing an instance named GP:

SQL Server 2014 Setup - Instance Configuration

Select and enter the password for the account SSRS should run under; as this set of posts ios about installing a test/demo system I am reusing the account used for SQL Server itself; on a live server it should be a separate account. Click Next when finished:

SQL Server 2014 Setup - Server Configuration

When installing SSRS standalone then the only configuration option is Install Only, so click Next to proceed:

SQL Server 2014 Setup - Reporting Services Configuration

Check your selections, click Back to make any required changes, or Install to start the installation:

SQL Server 2014 Setup - Ready to Install

Once the installation is complete a final window showing the status of the installation tasks; previous tasks will also be shown as you can see in the screenshot below which shows the components I installed in the last post:

SQL Server 2014 Setup - Complete

Click Close to close the SQL Server 2014 Setup utility.

Series=
SeriesPos=2

What should we write about next?

If there is a topic which fits the typical ones of this site, which you would like to see me write about, please use the form, below, to submit your idea.

Your Name

Your Email

Suggested Topic

Suggestion Details

Looking for support or consultancy with Microsoft Dynamics GP?

I no longer work with Microsoft Dynamics GP, but the last company I worked for was ISC Software in the UK; if you’re looking for support or consultancy services with Microsoft Dynamics GP you can contact them here.

6 thoughts on “Install SQL Server 2014: SSRS Installation

  1. Jonathan says:

    Nice write up. You might also want to link to or write up abut needing to manually modify the SSRS web.config to allow for the deployment of SSRS items via Dynamics.

    1. Ian Grieve says:

      Hi Jonathan,

      That is tomorrow’s post 🙂

      Ian

Leave a Reply

Your email address will not be published. Required fields are marked *