ApsaraDB RDS:Install and use SSRS on an ECS instance

Prerequisites

• An RDS instance is created. For more information, see Create an ApsaraDB RDS for SQL Server instance.

• An ECS instance that runs a Windows operating system is created. For more information, see Create an instance by using the wizard.

• SQL Server is installed on the ECS instance.

  Note

  The version of SQL Server on the ECS instance can be different from the version that run by the RDS instance.

Procedure

1. Download and install SSRS on the ECS instance.

2. Start the Report Server Configuration Manager. Configure the Server Name and Report Server Instance parameters. Then, click Connect.

   Note

   Report Server Configuration Manager automatically displays all the report server instances that are in the ECS instance. If multiple report server instances exist in the ECS instance, you must select an instance based on your business requirements.

   

3. In the left-side navigation pane, click Service Account and Web Service URL to configure parameters based on your business requirements.

   Note

   For more information, see Install SQL Server Reporting Services (2017 and later).

4. In the left-side navigation pane, click Database. On the right side of the page, click Change Database to create a report server database in the ECS instance.

   1. Select Create a new report server database and click Next.

   2. Enter the server name and click Next.

   3. Enter the database name and select a language for the script. Then, click Next.

      

   4. Configure the credentials for the account to connect to the report server and click Next.

   5. Confirm the information on the Summary page and click Next. Wait for the database to be created.

      

   6. Click Finish.

   Note

   For more information, see Install SQL Server Reporting Services (2017 and later).

5. In the left-side navigation pane, click Web Portal URL and click Apply. After the application operation is finished, click the URL to go to the Web portal of the report server.

   

6. In the upper-right corner of the page, choose New > Data Source.

7. Configure the parameters.

   Section	Parameter	Description
   Properties	Name	Enter the name of the data source. The name cannot contain the following special characters: / @ $ & * + = < > : ' , ? | \
   	Description	Specify a description for the data source to identify different data sources.
   	Hide	Click to hide the data source.
   	Enable	Click to enable the data source.
   Connections	Type	Select a type for the data source. Select Microsoft SQL Server.
   	Connection String	Specify the endpoint and the database name of the ApsaraDB RDS for SQL Server instance in the Data Source=<Endpoint of the RDS instance>; Initial Catalog=<Database name> format. Note Make sure the IP address of the ECS instance is added to the IP whitelist of the RDS instance. For more information, see Configure an IP address whitelist for an ApsaraDB RDS for SQL Server instance.
   Credentials	Data Source Login	Select Use the following credentials.
   	Credential Type	Select Database username and password.
   	Username	Enter the database account of the RDS instance.
   	Password	Enter the password of the database account.

8. Click Create.