All Products
Document Center

ApsaraDB RDS:Install and use SSRS on an ECS instance

Last Updated:Jun 14, 2023

You can install SQL Server Reporting Services (SSRS) on an Elastic Compute Service (ECS) instance and create reports based on the data in your ApsaraDB RDS for SQL Server instance. This topic describes how to install and use SSRS on an ECS instance.

Background information

Microsoft SQL Server contains server components such as SQL Server database engine, SSRS, and SQL Server Analysis Services (SSAS). The SQL Server database engine is a standard relational database component. ApsaraDB RDS for SQL Server is a PaaS that provides this database engine. Components such as SSRS run as Windows services, and are not provided as PaaS services in Alibaba Cloud.



  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.


    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.

  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.

  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.






    Enter the name of the data source. The name cannot contain the following special characters: / @ $ & * + = < > : ' , ? | \


    Specify a description for the data source to identify different data sources.


    Click to hide the data source.


    Click to enable the data source.



    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.


    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.


    Data Source Login

    Select Use the following credentials.

    Credential Type

    Select Database username and password.


    Enter the database account of the RDS instance.


    Enter the password of the database account.

  8. Click Create.

What to do next

After the data source is created, you can use software such as Report Builder and Visual Studio to design reports. For more information, see Report Builder in SQL Server.