tencent cloud

TencentDB for SQL Server

Release Notes and Announcements
Release Notes
Product Announcements
User Guide
Product Introduction
Overview
Product Architecture
Strengths
Use Cases
Regions and AZs
Major Version Lifecycle Explanation
Features and Differences
Instance Types
Instance Specifications
Storage Types
Common Concepts
Network Environment
License Statement
Purchase Guide
Billing Overview
Product Pricing
Purchase Methods
Renewal Instructions
Payment Overdue
Refund
From Pay-as-You-Go to Monthly Subscription
Instance Adjustment Fees Description
Local Backup Space Billing
Cross-Region Backup Billing
Viewing Bill Details
Getting Started
Creating TencentDB for SQL Server Instance
Connecting to TencentDB for SQL Server Instance
Managing TencentDB for SQL Server Instance
Operation Guide
Constraints and Limits
Usage Specifications and Suggestions
Maintaining Instance
Adjusting Instance Configuration
Read-Only Instance
Network and Security
Account Management
Database Management
Data Security
Parameter Configuration
Monitoring and Alarms
Backup and Restoration 
Log Management
Publish-Subscribe
SSIS
Data Migration (New)
Data Migration (Legacy)
Data Synchronization (DTS) 
Practical Tutorial
TencentDB for SQL Server Methods for Regular Maintenance
TencentDB for SQL Server Optimization of Slow SQL
How to Better Use Tempdb
Cross-Account Backup Restoration
Creating VPC for TencentDB for SQL Server
Connecting Kingdee K/3 WISE to TencentDB for SQL Server
Account Permissions and Permission Control
Enabling and Disabling the CDC Feature
Shrinking a Database
API Documentation
History
Introduction
API Category
Making API Requests
Sales and fee related APIs
Instance Management related APIs
Operation and maintenance management related APIs
Network management related APIs
Account management related APIs
Database management related APIs
Security group management related APIs
Data security encryption related APIs
Parameter configuration related APIs
Extended Event related APIs
Log management related APIs
Read only instance management related APIs
Publish and subscribe related APIs
Backup related APIs
Rollback related APIs
Data migration (cold standby migration) related APIs
SQL Server Integration Services (SSIS) related APIs
Data migration (DTS old version) related APIs
Data Types
Error Codes
FAQs
Overview
Model Selection
Pricing and Selection
Connection and Network
Account and Permission
Backup and Rollback
Data Migration
Publish/Subscribe
Read-Only Instance
Version and Architecture Upgrade
Disk Space and Specification Adjustment
Monitoring and Alarms
Log-Related
Parameter Modification
Features
Performance, Space, and Memory-Related FAQs
Service Agreement
Service Level Agreement
Terms of Service
Performance Evaluation
Performance Test Report
Glossary
Contact Us

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.

ヘルプとサポート

この記事はお役に立ちましたか?

フィードバック