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:
- Log in to the server that has Microsoft SQL Server installed.
- Search in the Start menu for “Report Server
Configuration Manager”.
- 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:
- Download the setup file from https://www.microsoft.com/en-us/download/details.aspx?id=55252.
- Log in as an administrator on the server where the SQL server is
installed.
- Open SQLServerReportingServices.exe. The following screen
will be displayed:
- Click Install Reporting Services. The following screen will
be displayed:
- Select the Enter the product key option, and type the product
key for SQL Server 2017.
- Click Next. The following screen will be displayed:
- 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.
- Click Next. The following screen will be displayed:
- Click Next. The following screen will be displayed:
- Select the location to install SSRS.
- Click Install. The following screen will be displayed:
- Once the installation is completed, the following screen will be
displayed
- 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
| Main Category: |
Support Product Know How |
Document Type: |
Online help main |
| Category: |
On-line help files |
Security level: |
All - 0 |
| Sub category: |
Details |
Document ID: |
28.428.250 |
| Assortment: |
Exact Synergy Enterprise
|
Date: |
10-04-2018 |
| Release: |
|
Attachment: |
|
| Disclaimer |