A MyBase for SQL Server instance of the High-availability Edition in an ApsaraDB for MyBase dedicated cluster supports SQL Server Integration Services (SSIS). This topic describes how to enable SSIS in ApsaraDB for MyBase.

Prerequisites

  • SQL Server is selected as the engine of an ApsaraDB for MyBase dedicated cluster.
  • A MyBase for SQL Server instance of the High-availability Edition is created. The privileged account sysadmin is created for the instance. For more information, see Host permissions.
  • A bastion host is configured for the instance and the Windows server account associated with the bastion host is granted the system administrative rights. For more information, see Access a Windows host from a bastion host.
  • SSIS is available only for a primary instance.

Note

SSIS can be enabled for the ApsaraDB for MyBase for SQL Server instance of the High-availability Edition. In some cases, the SSIS service can be unavailable and unstable. For example, the service or the MyBase for the SQL Server instance is unavailable if the application for this instance fails to install or the application configuration is invalid. In these cases, the service downtime in the ApsaraDB for MyBase service-level agreement (SLA) does not include the time when the SSIS service is unavailable.

Step 1: Use a bastion host to log on to a host

  1. Log on to the ApsaraDB for MyBase console.
  2. In the upper-left corner of the page, select the region where you want to deploy the dedicated cluster.
  3. In the left-side navigation tree, click Bastion Hosts. Find the bastion host that you want to manage, and click Associate with Bastion Host in the Actions column.
    s
  4. In the Import Host step, import a host that is deployed in the dedicated cluster and create an account for the primary instance that is deployed on the host.
    Note Configure Username and Password. You must set Account Type to Administrator. Otherwise, you cannot enable SSIS.
  5. After you create an account for the primary instance, click Next to go to the Authorize Host step.
    Note For more information about how to connect to a host from a bastion host, see Access a Windows host from a bastion host.
  6. Start RDC on your local host.
  7. Enter <Bastionhost O&M address>:63389 and click Connect.
    Start RDC
  8. Enter a username and password to log on to the bastion host.
    Note Use the username and password that you specified when you created the bastion host.
  9. Find the primary instance that you want to connect, and double-click the instance name. This way, you can connect to the instance by using the Remote Desktop client on Windows.
    Note On the Instances page in the ApsaraDB for MyBase console, you can view the details about the primary instance . For more information, see View host details.

Step 2: Enable SSIS

  1. Log on to the Windows server that runs the primary instance. Open the Start menu and select the SQL Server version that you use. On the menu that appears, right-click SQL Server 2016 Configuration Manager and choose More > Run as administrator.
    s
    Note Select the SQL Server version that you specified when you created the instance.
  2. Click SQL Server Services and double-click SQL Server Integration Services 13.0. In the dialog box that appears, click the Service tab, set Start Mode to Automatic, and then click Apply.
    a
  3. In the SQL Server Integration Services 13.0 Properties dialog box, click the Log On tab, click Start, and then click Apply. Wait a few seconds until the value of Service status changes to Running.
    s
  4. Log on to the Windows server that runs a secondary instance of MyBase for SQL Server, and perform the preceding operations again to enable SSIS.

Step 3: Use SSMS to connect to a database instance

  1. Download and install Microsoft SQL Server Management Studio (SSMS) on your on-premises machine.
  2. Return to the ApsaraDB for MyBase console. On the Instances page, find the instance that you want to connect, and click the instance ID.
  3. In the left-side navigation pane of the instance configuration page, click Database Connection and obtain SQL Server Management Studio Connection Method (Server Name).
  4. Open the Microsoft SQL Server Management Studio client to connect to the database instance. Set Server type to Integration Services, specify Server name, and then select Windows Authentication. Then, click Connect.