You can create an account that has the system admin permissions on an ApsaraDB RDS for SQL Server instance. You can use this account to migrate data from an on-premises SQL Server instance to your RDS instance.

Prerequisites

  • Your RDS instance runs one of the following SQL Server versions and RDS editions:
    • SQL Server 2017 EE on RDS Cluster Edition
    • SQL Server 2012 SE, 2012 EE, 2016 SE, 2016 EE, 2017 SE, and 2019 SE on RDS High-availability Edition
  • Your RDS instance belongs to the general-purpose or dedicated instance family.
  • Your Alibaba Cloud account is used to log on to the ApsaraDB RDS console.
  • Your RDS instance was created on or after January 1, 2021.
Note
  • This feature is supported only for specific customers. If you want to use this feature, submit a ticket or contact your customer manager.
  • You can view the Creation Time parameter of your RDS instance in the Status section on the Basic Information page.

Precautions

Warning After a system admin account is created, the service quality that is specified in Alibaba Cloud service level agreement (SLA) cannot be guaranteed. For more information, see SLA.
  • You can create only one system admin account per RDS instance.
  • RDS instances in the Cloud Tmall system do not support system admin accounts.
  • The following usernames cannot be used for system admin accounts:
    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$

Procedure

  1. Log on to the ApsaraDB RDS console.
  2. In the top navigation bar, select the region where your RDS instance resides.
  3. Find your RDS instance and click its ID.
  4. In the left-side navigation pane, click Accounts.
  5. Click Create Account and configure the following parameters.
    Create a system admin account
    Parameter Description
    Database Account Enter the username of the account. The username must be 2 to 16 characters in length and can contain lowercase letters, digits, and underscores (_). It must start with a lowercase letter and end with a lowercase letter or digit.
    Account Type Select System Admin Account. Then, read the agreement and select I have read and agree to changes to the RDS Service Level Agreement caused by the creation of a system admin account.
    Warning After a system admin account is created, the service quality that is specified in Alibaba Cloud SLA cannot be guaranteed. For more information, see SLA.
    Password

    Enter the password of the account. The password must meet the following requirements:

    • The password must be 8 to 32 characters in length.
    • The password must contain at least three of the following character types: uppercase letters, lowercase letters, digits, and special characters.
    • The password can contain any of the following characters: !@#$%^&*()_+-=
    Confirm Password Enter the password of the account again.
    Description Enter a description that helps identify the account. The description can be up to 256 characters in length.
  6. Click Create.
A system admin account is created