ApsaraDB RDS:Create and log on with a host account

When to use a host account

Supported configurations

The RDS instance must meet all of the following requirements:

• Runs RDS Basic Edition, RDS High-availability Edition, or RDS Cluster Edition. For High-availability Edition, the instance must run SQL Server 2012 or later.

• Belongs to the general-purpose or dedicated instance family. The shared instance family is not supported.

• Uses the subscription or pay-as-you-go billing method. Serverless instances are not supported.

• Resides in a virtual private cloud (VPC). To change the network type, see Change the network type.

• Was created on or after the following dates:

  Note

  Check the Creation Time parameter in the Status section of the Basic Information page in the ApsaraDB RDS console.

  Edition	Minimum creation date
  RDS High-availability Edition or RDS Cluster Edition	January 01, 2021
  RDS Basic Edition	September 02, 2022

• An Alibaba Cloud account is used to log on to the RDS instance.

Restrictions

• Jushita does not support host accounts.

• Each RDS instance supports only one host account with System Admin permissions.

• The host account name cannot use any reserved keywords.

• When the instance is migrated across hosts (such as during a major version upgrade, minor engine version upgrade, specification change with major version upgrade, or zone migration), the host account and any programs or files deployed on the original host (such as SSIS, SSAS, and SSRS) are deleted. Back up or migrate your data before performing these operations.

Actions that may disrupt your instance

The host account has extensive permissions beyond the control of ApsaraDB RDS for SQL Server. Follow these guidelines to avoid service disruptions:

Step 1: Create a host account

1. Go to the Instances page. In the top navigation bar, select the region of your RDS instance, and then click the instance ID.

2. In the left-side navigation pane, click Accounts.

3. Click the Host Account tab, and then click Create Account.

4. Configure the following parameters.

   Parameter	Description
   Host Account Name	Lowercase letters, digits, or underscores (_). Must start with a letter and end with a letter or digit. Maximum length: 16 characters.
   Account Type	Standard Account: Creates a standard host account. System Admin Account: Creates a host account with System Admin permissions. Only one System Admin account is allowed per instance. For more information, see Database accounts with SA permissions.
   New Password	8 to 32 characters. Must contain at least three of the following: uppercase letters, lowercase letters, digits, and special characters (!@#$%^&*()_+-=).
   Confirm Password	Re-enter the password.
   Remarks	Optional. Maximum length: 256 characters.

5. Select I Have Read And Agree To The Changes To The RDS Service Level Agreement For Creating A Host Account.

6. Click OK.

Manage an existing host account

In the Actions column, click Reset Password or Delete to manage the account.

Step 2: Log on to the host

1. Go to the Instances page. In the top navigation bar, select the region of your RDS instance, and then click the instance ID.

2. In the left-side navigation pane, click Accounts.

3. Click the Host Account tab. In the Actions column, click Remote Connection (Primary).

4. In the Remote Connection dialog box, enter the host account password.

   

5. Click OK. The system generates a WebShell URL and opens a new browser tab with the host session. If your browser blocks the pop-up window, allow pop-ups from this site.

   

FAQ

Next steps

• Use SSRS to manage and operate the SQL Server database

API reference

Reserved keywords

The following keywords cannot be used as host account names:

root, admin, eagleye, master, aurora, sysadmin, administrator, mssqld, public, securityadmin, serveradmin, setupadmin, processadmin, diskadmin, dbcreator, bulkadmin, tempdb, msdb, model, distribution, mssqlsystemresource, guest, add, except, percent, all, exec, plan, alter, execute, precision, and, exists, primary, any, exit, print, as, fetch, proc, asc, file, procedure, authorization, fillfactor, public, backup, for, raiserror, begin, foreign, read, between, freetext, readtext, break, freetexttable, reconfigure, browse, from, references, bulk, full, replication, by, function, restore, cascade, goto, restrict, case, grant, return, check, group, revoke, checkpoint, having, right, close, holdlock, rollback, clustered, identity, rowcount, coalesce, identity_insert, rowguidcol, collate, identitycol, rule, column, if, save, commit, in, schema, compute, index, select, constraint, inner, session_user, contains, insert, set, containstable, intersect, setuser, continue, into, shutdown, convert, is, some, create, join, statistics, cross, key, system_user, current, kill, table, current_date, left, textsize, current_time, like, then, current_timestamp, lineno, to, current_user, load, top, cursor, national, tran, database, nocheck, transaction, dbcc, nonclustered, trigger, deallocate, not, truncate, declare, null, tsequal, default, nullif, union, delete, of, unique, deny, off, update, desc, offsets, updatetext, disk, on, use, distinct, open, user, distributed, opendatasource, values, double, openquery, varying, drop, openrowset, view, dummy, openxml, waitfor, dump, option, when, else, or, where, end, order, while, errlvl, outer, with, escape, over, writetext, dbo, login, sys, drc_rds