Exact Synergy Enterprise

How-to: Installing SQL Server Reporting Services (SSRS)

Introduction

SQL Server Reporting Services (SSRS) is a server-based report generating software system from Microsoft. SSRS is part of Microsoft SQL Server, and can be used by the Reporting Services Integration functionality in Exact Synergy Enterprise. SSRS is also used by the dashboards in Exact Globe Next with extended functionality.

From SQL Server 2017 onwards, SSRS must be installed via a separate installer. The following describes the SSRS installation.

For more information on the supported version of the SQL server and the corresponding product update of Exact Globe Next and Exact Synergy Enterprise, see Hardware and software requirements for Exact Globe Next and Hardware and software requirements for Exact Synergy Enterprise.

Note: Before installing SSRS, it is advisable to check whether SSRS is already installed in your system.

Checking SSRS

To check if SSRS is already installed in your system, do the following:

1. Log in to the server that has Microsoft SQL Server installed.
2. Search in the Start menu for “Report Server Configuration Manager”.
3. If the “Report Server Configuration Manager” is available, this means the reporting services feature is already installed. However, if “Report Server Configuration Manager” is not available, install the reporting services feature.

Installing SSRS

To install SSRS, do the following:

1. Download the setup file from https://www.microsoft.com/en-us/download/details.aspx?id=55252.
2. Log in as an administrator on the server where the SQL server is installed.
3. Open SQLServerReportingServices.exe. The following screen will be displayed:



4. Click Install Reporting Services. The following screen will be displayed:



5. Select the Enter the product key option, and type the product key for SQL Server 2017.
6. Click Next. The following screen will be displayed:



7. In the Review the license terms screen, read the license terms. If you agree with the license terms, select the I accept the license terms check box.
8. Click Next. The following screen will be displayed:



9. Click Next. The following screen will be displayed:



10. Select the location to install SSRS.
11. Click Install. The following screen will be displayed:



12. Once the installation is completed, the following screen will be displayed



13. Restart the system.

If you upgraded from the previous version of the SQL server to SQL Server 2017, and have a backup of your report server database and encryption, you have to select or restore the files in Report Server Configuration Manager.

• Firstly, restore the backup of the report server database via SQL Server Management Studio.
• Start Report Server Configuration Manager, and connect to the SQL server.
• In Report Server Configuration Manager, select the report server database in the Database menu, and restore the backup of the encryption key in the Encryption keys menu.

Related documents

• How-to: Installing SQL Server 2017 Standard Edition
• How-to: Updating SQL Server 2017