ApsaraDB RDS:Install and use SSRS on an ECS instance

Prerequisites

Before you begin, ensure that you have:

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

• An ECS instance running Windows. For more information, see Create an instance by using the wizard.

• SQL Server installed on the ECS instance. For more information, see Install SQL Server. The SQL Server version on the ECS instance can differ from the version on the RDS instance.

Step 1: Install SSRS

Download and install SSRS on the ECS instance from the Microsoft Download Center.

Step 2: Configure the report server

Use Report Server Configuration Manager to configure four components in sequence: service account, web service URL, report server database, and web portal URL.

1. Start Report Server Configuration Manager. Set the Server Name and Report Server Instance, then click Connect.

   Report Server Configuration Manager automatically lists all report server instances on the ECS instance. If multiple instances exist, select the one that matches your requirements.

   

2. In the left-side navigation pane, click Service Account and configure the service account parameters.

3. Click Web Service URL and configure the URL parameters. For configuration details, see Install SQL Server Reporting Services (2017 and later).

4. Click Database, then click Change Database to create a report server database on the local SQL Server instance on 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, select a language for the script, and click Next.

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

   5. Review the Summary page and click Next. Wait for the database to be created.

   6. Click Finish.

5. Click Web Portal URL, then click Apply. When the URL appears, click it to open the web portal.

   

Step 3: Create a data source

1. In the upper-right corner of the web portal, choose New > Data Source.

2. Configure the data source parameters: For the Connection string field, use this format:

   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.

   Section	Parameter	Value
   Properties	Name	Enter a name. The following special characters are not allowed: `/ @ $ & * + = < > : ' , ?	\`
   	Description	Optional. Helps distinguish multiple data sources.
   	Hide	Click to hide this data source from report users.
   	Enable	Click to enable this data source.
   Connections	Type	Select Microsoft SQL Server.
   	Connection string	Use the format below.
   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.

   Data Source=<Endpoint of the RDS instance>; Initial Catalog=<Database name>

   

3. Click Create.

What to do next

After the data source is created, use Report Builder or Visual Studio to design reports that connect to the data source. For more information, see Report Builder in SQL Server.