This topic describes how to connect to an instance via logging on to the data interaction platform for RDS for SQL Server to on the Database Workshop (DBW) console.

Prerequisites

An instance has been created and the instance state is Running. For detailed steps, see Creating an instance.

A database account has been created. For detailed steps, refer to Creating and managing an account.

Precautions

Instances with security control enabled support password-free login on the data interaction platform. For detailed steps, refer to Enabling security control.

When you select Authorize Database Workshop to add service IPs to the corresponding database instance allowlist, the IP address of the DBW backend service host will be added to the allowlist of the database instance. The name of the allowlist is in the DBW_Sole_****_****_For_mssql format.

Log out and log in again to restore all pages to their state before logging out.

After 5 consecutive failed login attempts due to an incorrect username or password, DBW will lock the login for one minute. Try again after one minute.

Do not modify or delete the allowlist during the login process, as this will prevent opening new command windows to execute commands, although the current window can continue to execute commands.

It supports logging into both the primary instance and read-only instances.

Procedure

Log on to the SQL window through the DBW console

Log on to the SQL window through the RDS for SQL Server console

Log on to the DBW console.

On the top menu bar, select the region.

Choose one of the following methods to log on to the Database interaction platform:

Method 1: On the left navigation bar, select Data management > SQL window.

Method 2;

On the left navigation bar, click Instance list.

In the upper-left corner of the Instance list page, set the database type to RDS for SQL Server and find the target instance.

In the Actions column of the target instance, click Login.

In the Database Workshop dialog box, set the relevant parameters as shown in the table below.

Parameter	Description
Instance type	From the drop-down list, select RDS for SQL Server.
Instance name	From the drop-down list, select a target instance from Recently logged in or All. Fuzzy search is supported.
Database account	Enter the database account name.
Database password	Enter the database account password.
Database name	Optional. Enter the database name as needed. The master database is used by default.

Check Remember password, Authorize Database Workshop to add service IPs to the corresponding database instance allowlist, and then click Login.

After remembering the password, you won’t need to enter it for subsequent logins, helping to improve work efficiency. When you need to clear a remembered password, you can click Clear record for the target account in the Database account drop-down list, which will forget the account password.

Next steps

After logging in, you can perform the following operations in the command window:

Execute statement commands. For more information, refer to Command operations.

Click Observation and diagnosis to perform operation and maintenance management on the instance. For more information, refer to Observation and diagnosis.

Click Instance details to view the details of the instance. For more information, refer to Viewing instance information.

Click Log out to exit the instance workbench.