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

Microsoft SQL ServerIn 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.

Microsoft Dynamics GP ships with some Reporting Services Reports by default, so this componenbt of SQL Server also needs to be installed. As with SSMS, SQL Server Reporting Services (SSRS) is not installed by the main installer, but, again like SSMS, it is available via a download accessible tyhrough the setup utility.

To install SSRS, laucnh the main setup utility of SQL Server, click Installation and then select Install SQL Server Reporting Services:

SQL Server Installation Center - Installation

The web page will open in your default browser. Click the red Download link and save the download:

Download SSRS

Launch the downloaded file, and click the Install Reporting Services button:

Microsoft SQL Server 2017 Reporting Services - Welcome

Select an efition to install or enter a product key; I am installing a test system so have selected to install the Developer Edition. Click Next once you have made your selection or entered the product key:

Microsoft SQL Server 2017 Reporting Services - Choose an edition to install

Accept the terms of the license agreement and click Next:

Microsoft SQL Server 2017 Reporting Services - Review the license terms

There is only one option available, so click Next:

Microsoft SQL Server 2017 Reporting Services - Install Database Engine

Confirm, or change if necessary, the install location of SSRS and click Install:

Microsoft SQL Server 2017 Reporting Services - Specify an install location

Once the installation is complete, you can either click Close to close the installer and manaully configure SSRS later, or you can click Configure report server to begin the configuration:

Microsoft SQL Server 2017 Reporting Services - Setup completed

I'll cover the configuration in the next post.

Can ISC Software Solutions help?

ISC Software Solutions are UK and Ireland based experts on Microsoft Dynamics GP. If you'd like to speak to someone about support, consultancy, upgrades, implementation, development, GP Elementz add-ons or portals, or anything else Dynamics GP related, you can use the form below.

Your Name (required):
Your Email (required):
Enquiry message:

What should we write about next?

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

Leave a Reply

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