tencent cloud

TencentDB for SQL Server

문서TencentDB for SQL ServerOperation GuideAccount ManagementCreating Admin Account

Creating Admin Account

PDF
포커스 모드
폰트 크기
마지막 업데이트 시간: 2025-10-11 10:29:40
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 support creating an account with the system admin (SA) permission, also known as an admin account. Due to business security and risk control requirements, the system may prompt you to restart the instance in rare cases to enable this feature when you create an admin account. At this point, follow the prompt in the console to complete the instance restart before you perform the admin account creation operation.
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
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 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.

Related APIs

API
Description
This API is designed for the creation of instance accounts.
이전 주제: Creating Account다음 주제: Creating Designated Account

도움말 및 지원

문제 해결에 도움이 되었나요?

피드백