Install SQL Server 2014: SSRS Configuration

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 last post, I stepped through the installation of SSRS. As I mentioned in that post, I prefer to do the configuration separately, as I have had problems with the automatic configuration.

To configure SSRS, launch Reporting Services Configuration Manager from the Windows Start screen.

The first window launched is the Reporting Services Configuration Connection one; ensure the Server Name is correct and that the Report Server Instance is the one to be configured and click Connect:

Reporting Services Configuration Connection

The Report Server Status page will show that the service is started, but not configured. Each stage needs to be configured in turn. Click on Service Account:

Reporting Services Configuration Manager - Report Server Status

I do not like using a built-in account for running services, so I have marked Use another account and entered an Account (Domain\user) and Password. Click the Apply button and then click on Web Service URL:

Reporting Services Configuration Manager - Service Account

Check the settings and then click Apply. Once the apply has finished, click on Database:

Reporting Services Configuration Manager - Web Service URL

The Database stage is a longer multi-stage one. Click the Change Database button to continue:

Reporting Services Configuration Manager - Database

This is a new Report Server being configured so leave Create a new report server database marked and click Next:

Reporting Services Configuration Manager - Change Database - Action

Enter the SQL Server, including instance name, in the Server Name and select an Authentication method. If your user has sysadmin permissions you can uise Current User – Integrated Security otherwise change the setting to SQL Authentication and enter the Username and Password and then click Next:

Reporting Services Configuration Manager - Change Database - Database Server

Check the default database settings, make any changes required and then click Next:

Reporting Services Configuration Manager - Change Database - Database

I always use the Service Credentials for the report server to connect to the database so simply click Next to proceed:

Reporting Services Configuration Manager - Change Database - Credentials

Check the information on the summary stage, click Back should you want to change anything, otherwise click Next:

Reporting Services Configuration Manager - Change Database - Summary

Wait while the configuration progresses and then click Finish:

Reporting Services Configuration Manager - Change Database - Progress and Finish

The Report Server Database stage will now display the details of the database and credentials. Click on Report Manager URL:

Reporting Services Configuration Manager - Change Database - Report Server Database

Check the default setting and click Apply and then click on Encryption Keys:

Reporting Services Configuration Manager - Change Database - Report Server URL

It is best to back up the key to a password protected file in case of needing to recover the report server. CLick Backup

Reporting Services Configuration Manager - Change Database - Encryption Keys

Select a File Location, enter the Password and Confirm Password and click OK:

Backup Encryption Key

Click the Exit key to close the Reporting Services Configuration Manager:

Reporting Services Configuration Manager - Change Database -  Encryption Keys

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.

Leave a Reply

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