tencent cloud

TencentDB for SQL Server

DocumentationTencentDB for SQL ServerOperation GuideAccount ManagementCreating an Admin Account

Creating an Admin Account

Download
Focus Mode
Font Size
Last updated: 2026-07-22 16:28:38
This document describes how to create admin accounts for a TencentDB for SQL Server instance through the console and provides related information.

Admin Account Description

The SA (System Admin) role is the most powerful role in SQL Server. It completely bypasses all security checks and can perform any operation in SQL Server. TencentDB for SQL Server single-node (formerly Basic Edition) supports creating accounts with SA (System Admin) permissions, which are admin accounts. Due to business risk and security control requirements, when an admin account is created, the system may, in rare cases, prompt you to restart the instance to activate this feature. In such cases, please restart the instance as prompted by the console before proceeding to create the admin account.
Warning:
Once an admin account is created for an instance, the sysadmin permissions are granted. Instances with SA permissions will no longer be covered by the SLA. Database instances without SA permissions are not affected.
Only one account with SA permissions can be created for an instance.
After SA is enabled for an instance, do not change the recovery model from Full to Simple. Otherwise, the instance will not be able to perform log backup or point-in-time recovery, which may result in data loss.
After SA is enabled for an instance, the service availability, management availability, data availability, data reliability, and data security of the instance cannot be guaranteed. This is because the SA permissions granted to the account are excessive and the operational permissions it possesses exceed the control scope of TencentDB for SQL Server management.

Operation Steps

1. Log in to the TencentDB for SQL Server console, click the Instance ID or Manage in the Operation column, and go to the instance management page.
2. On the instance management page, select Account Management > Create Account, enter relevant information in the pop-up dialog box, and then click OK after confirmation.
Parameter
Description
Account Name
The account name requires 1 to 50 characters, consisting of letters, digits, or special characters (underscores). It should start with a letter.
The account name cannot contain the following reserved keywords: master, mssql, monitor, sys, dbo, dba, sysadmin, tencent_admin, public, securityadmin, serveradmin, setupadmin, processadmin, diskadmin, dbcreator, bulkadmin, administrator (case-insensitive), and guest (case-insensitive).
The account name cannot contain the following sensitive characters: .|##|( | )|[ | ]|,|`|;|'|"|\\|--|xp_cmdshell|sp_addsrvrolemember.
Account Type
Select admin accounts.
Warning:
Because admin accounts have the highest administrative permissions, the product will no longer guarantee the instance SLA after they are enabled.
Database
Admin accounts have owner permissions for all databases by default.
New Password
The password requires 8 - 32 characters and must contain at least two of the following: letters, digits, and the symbols _+-&=!@#$%^*()[].
Confirm Password
Re-enter the password.
Remarks
Optional. You can enter remarks, up to 256 characters.

Related APIs

API
Description
This API is used to create an instance account.
Previous Topic: Creating an Admin AccountNext Topic: Resetting Password

Help and Support

Was this page helpful?

Help us improve! Rate your documentation experience in 5 mins.

Feedback