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. Open Report Server Configuration Manager, confirm the report server name, and then click Connection.

   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.

   In the Report Server Configuration Connection dialog box, confirm the Server Name, select SSRS from the Report Server Instance drop-down list, and then click Connect.

3. In the left navigation pane, configure the Service Account and Web Service URL.

   Note

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

4. In the left navigation pane, select Database, and then click Change Database on the right to create a new report server database on the ECS instance.

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

   2. Confirm the server name and click Next.

   3. Enter a Database Name, select a language, and then click Next.

      For example, enter ReportServertest for Database Name, select your preferred Language, and ensure Report Server Mode is set to Native.

   4. Specify the credentials used to connect to the report server, and then click Next.

   5. Review the summary and click Next. Wait for the report server database to be created.

      After all tasks complete successfully, click Finish to close the wizard.

   6. Click Done.

   Note

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

5. In the left navigation pane, select Web Portal URL. Click Apply. Then, click the provided URL to log in to the report server web portal.

6. In the upper-right corner, select Create > Data Source.

7. Configure the parameters.

   Section	Parameter	Description
   Attribute	Name	Enter the name of the data source. The name cannot contain the following special characters: / @ $ & * + = < > : ' , ? | \
   	Notes	Specify a description for the data source to identify different data sources.
   	Hide this item	Click to hide the data source.
   	Enable this data source	Click to enable the data source.
   Connection	Type	The type of data source. Select Microsoft SQL Server.
   	Connection Character 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.
   Credentials	Connect using	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.