tencent cloud

PrevNext

Feedback

search by keyword

Recent Pages

Documentation
TencentDB for SQL Server
    Documentation
    Download PDF

    Creating Admin Account

    Last updated: 2024-09-05 12:23:19
    Download PDF
      This document describes how to create an admin account for a TencentDB for SQL Server instance in the console.

      Admin account description

      The System Admin (SA) role is the most privileged role in SQL Server. It can perform any operations in SQL Server without passing any security checks. TencentDB for SQL Server single-node (formerly Basic Edition) instances allow you to create an admin account with the SA privilege, so you can use the account to quickly adapt offline software and move it to the cloud. Currently, the admin account cannot be directly created via the console. If necessary, submit a ticket to obtain a solution.
      Warning:
      Once an admin account is created for an instance, the sysadmin privilege is enabled, and the product SLA will no longer be guaranteed for the instance. Database instances that do not have admin accounts with the SA privilege are not affected.
      You can create only one SA account for each instance.

      Directions

      1. Log in to the TencentDB for SQL Server console. Click an instance ID or Manage in the Operation column to access the instance management page.
      2. On the instance management page, select Account Management > Create Account and enter relevant information in the pop-up window. After confirming that everything is correct, click OK.
      
      Parameter
      Description
      Account Name
      It can contain 1–50 letters, digits, or underscores and must start with a letter.
      The account name cannot contain the following keywords or symbols: sysadmin, sp_addsrvrolemember, master, mssql, ##, [|], ,, 。 ., ;, ( | ), --.
      Account Type
      Select Admin Account.
      Warning:
      As the admin account has the highest-level management permissions, the instance SLA will not be guaranteed after this account is enabled.
      Database
      The admin account has the owner permissions of all databases by default.
      New Password
      The password must contain 8–32 characters in at least two of the following types: letters, digits, and symbols _+-&=!@#$%^*()[].
      Confirm Password
      Enter the password again.
      Remarks
      Optional. It can contain up to 256 characters.
      Contact Us

      Contact our sales team or business advisors to help your business.

      Contact Us
      Technical Support

      Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

      Submit a Ticket
      7x24 Phone Support
      Copyright © 2013-2024 Tencent Cloud. All Rights Reserved.
      Privacy PolicyLegalCookie Policy