How to Install Microsoft SQL Server 2017: Configure SQL Server Reporting Services

Microsoft Dynamics GPIn this short series of posts, I am going to be covering the installation of Microsoft SQL Server 2017; the installation process for this version is somewhat different to previous ones, in that SQL Server Management Studio and SQL Server Reporting Services have been separated out from the main installer.

The series index can be found here. I am not a SQL expert and this series of posts is intended only for use on demo or test environment and not production ones.

In the last post I covered the installation of SQL Server Reporting Services (SSRS); in this post I am going to cover the basic configuration of SSRS.

To complete the configuration, launch the Report Server Configuration Manager; ensure the Server Name is set to the correct name and click the Connect button:

The Report Server Configuration Connection

Once Report Server Configuration Manager starts, click on Service Account in the navigation list to the right of the window.

SSRS is best to run under a Domain account. To set this, click Use another account and enter the Account (Domain\user) and password.

Click the Apply button and wait for the Results section to display the result of the applied action:

Report Server Configuration Manager: 2018\SSRS - Service Account

Click on Web Service URL and verify the details; if the details are not correct, update them and then click Apply:

Report Server Configuration Manager: 2018\SSRS - Web Service URL

Click Database to configure the Report Server Database. As this is a new server I am configuring, I will be using a new database.

Click the Change Database button:

Report Server Configuration Manager: 2018\SSRS - Report Server Database

Mark the Create a new report server database radio button and click Next:

Report Server Database Configuration Wizard - Change Database - Action

The connection details for the Database Server need to be supplied.

Enter the Server Name, which is the full instance name of the SQL Server which will host the report server database.

Select the Authentication Type; I typically use SQL Server Account to ensure I have all the required permissions (such as creating a database), but in this case I am logged in as the administrator account which installed SQL Server so have left the option at Current User – Integrated Security.

Click Test Connection to verify the supplied details:

Report Server Database Configuration Wizard - Change Database - Database Server

Click OK to accept the results of the test and click Next:

Test Connection

The Database Name will default to ReportServer, but can be changed if necessary. Click Next to continue:

Report Server Database Configuration Wizard - Change Database - Database

A service account is needed to connect to the database server; I have installed both SQL Server and SSRS using the same account so have left the Authentication Type as Service Credentials. Click Next to continue:

Report Server Database Configuration Wizard - Change Database - Credentials

Review the Summary and click Next to finalise the configuration of the report server database:

Report Server Database Configuration Wizard - Change Database - Summary

Once the wizard has completed, click Finish:

Report Server Database Configuration Wizard - Change Database - Progress and Finish

Back on the Report Server Database page, click ApplyReport Server Configuration Manager: 2018\SSRS - Report Server Database

Click Web Portal URL and then hit the Apply button:

Report Server Configuration Manager: 2018\SSRS - Web Portal URL

There are other options which can be configured for SSRS, but I am installing it for use only on a demo environment and am configuring only the essentials.

Click to show/hide the How to Install Microsoft SQL Server 2017 Series Index

What should we write about next?

Your Name (required) -
Your Email (required) -

(Visited 8 times, 1 visits today)