How To Install Microsoft SQL Server 2016: Configuring SQL Server Reporting Services

Microsoft SQL ServerThis is a short series of posts on how to install Microsoft SQL Server 2016; the series index can be found here.

In the last post, I installed the SQL Server Database Engine and the Reporting Services, but I did not configure Reporting Services. I mentioned that I have had problems before when doing this, so always do it separately.

To configure SQL Server Reporting Services (SSRS), launch Reporting Services Configuration Manager from the Windows Start menu.

Select the Report Server Instance to connect to and click Connect:

Reporting Services Configuration Connection

Once the Reporting Services Configuration Manager has launched click on Service Account in the navigation pane:

Reporting Services Configuration Manager: HANDSON2016R2\GP

Check the service account and make changes if necessary and then click Web Servie URL:

Reporting Services Configuration Manager: Service Account

If you want to configure the Web Serviec URL with an SSL certificate, select a valid one in the HTTPS Certificate field and confirm the HTTPS Port.

Click Apply to apply the changes and configure the URL.

Click on Database in the navigation pane.

Reporting Services Configuration Manager: Web Service URL

A database is required for all report server content and application data. To create a new database, click on Change Database:

Reporting Services Configuration Manager: Database

Leave the Create a new report server database and click Next:

Report Server Database Configuration Wizard: Action

Enter the full instance name of the SQL Server which will host the Reporting Services database in the Server Name field.

If your user has permissions to create databases, you can use an Authentication Type of Current User – Integrated Security, otherwise change it to SQL Server Account and enter a Username and Password.

Click Test Connection to validate the supplied details.

Click Next:

ReportServer Database Configuration Wizard: Database Server

A Database Name will default in, but this can be changed.

Click Next to proceed:

ReportServer Database Configuration Wizard: Database

I have left the Credentials set to the SQL Server service account, but this could be changed if necessary.

Click Next:

ReportServer Database Configuration Wizard: Credentials

Review the Summary and click Next when ready to proceed:

ReportServer Database Configuration Wizard: Summary

Once the creationof the new database is complete, click Close:

ReportServer Database Configuration Wizard: Progress and Finish

Ensure the Results show the dataabase create task completed successfully and then click on Web Portal URL:

ReportServer Database Configuration Wizard: Database

Review the Virtual Directory for the Web Portal URL and click Apply:

Reporting Services Configuration Manager: Web Portal URL

Close the Reporting Services Configuration Manager.

When configuring SSRS for Microsoft Dynamcis GP, there is one final step required; this step involves editing the web.config file.

The file is located, for SQL Server 2016, in %ProgramFiles%\Microsoft SQL Server\MSRS13.GP\Reporting Services\ReportServer.

Find the line:

<httpRuntime executionTimeout="9000" requestValidationMode="2.0" />

And add the following to the end:

maxRequestLength="20690"

You should then have a line which looks like the below:

Reporting Services Configuration Manager:

<httpRuntime executionTimeout="9000" requestValidationMode="2.0" maxRequestLength="20690" />

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 *