Configure SQL server reporting services

Set up SQL Server Reporting Service

1. From the Start menu, under Microsoft SQL Server Reporting, select Report Server Configuration Manager.

   The Reporting Services Configuration Manager window appears.

2. Configure the Web Service URL to access the Report Sever.

   To configure the Web Service URL:

   1. Select Web Service URL under Connect.

   2. Select Apply with all default values.

   The Web Service URL is configured successfully.

   

3. Create the Report Server Database to store all report content and application data.

   To configure the Report Service Database:

   1. Select Database under Connect.

   2. Select Apply with all default values.

   The database is created successfully. 

   

4. Create the Web Portal URL to access the Web Portal.

   To create the Web Portal URL:

   1. Select Web Portal URL under Connect.

   2. Select Apply with the default values.

   The Web Portal URL is created successfully.

   

5. To delete Encryption Keys:

   1. Select Encryption Keys under Connect.

   2. Under Delete Encrypted Content, select Delete.

   3. Select Apply.

   The encryption content is cleared successfully.

   

   Note: The above steps are required for the installation of the SP 2020 or lower versions. For SP 2020 R2 and later, the reports are automatically deployed with the installation.

6. Deploy the AVEVA System Monitor reports to SQL Server Reporting Services. 

   Upgrading from lower version SP 2020 / SP 2017 U3 / SP 2017 U3 SP1 to SP 2023 R2:

   Case 1: If the reports are already configured and running before upgrading to SP 2023 R2, there is no change in the SSRS installation process.

   Case 2: If the reports are not configured, follow the steps below:

   Note: If SSRS is installed and configured during AVEVA System Monitor installation, deploy the reports to the report server. This requires no configuration of SSRS beyond the default configuration. If the SSRS is not installed and configured during AVEVA System Monitor installation, run the PublishReports.cmd command by providing the parameters, as described below.

   1. After successfully installing AVEVA System Monitor, navigate to C:\ProgramData\Sentinel System Monitor\Sentinel Manager\DataFolder\SSRSReports.

   2. Open the Command Prompt as an Administrator.

   3. In the Command Prompt, navigate to the SSRSReport folder using the command displayed in the following screen.

      

   4. After successfully navigating to the folder, run the PublishReports.cmd command by providing the following parameters:

   Case 1: For Upgrading from lower versions to SP 2020 R2 and higher version, and if the reports are not deployed

   Parameter	Value	Comments
   SQL Server Name	<SQLServerMachineName> Example: SMTEST4	Any SQL server where we are configuring the reports

   The Command Prompt window appears as follows.