TencentDB for SQL Server
- Release Notes and Announcements
- Announcements
- Product Introduction
- Product Architecture
- Instance Specifications
- Purchase Guide
- Product Pricing
- Getting Started
- Connecting to TencentDB for SQL Server Instance
- Operation Guide
- Maintaining Instance
- Adjusting Instance Configuration
- Read-Only Instance
- Network and Security
- Account Management
- Database Management
- Data Security
- Access Management
- Parameter Configuration
- Monitoring and Alarms
- Backup and Restoration
- Backup
- Setting Automatic Backup
- Log Management
- Publish-Subscribe
- SSIS
- Data Migration (New)
- Using DTS to Migrate Data
- Pre-Validation Failure Handling
- Data Migration (Legacy)
- Migrating Data from SQL Server Instance Purchased at Other Cloud Service Provider or Built In-house
- Practical Tutorial
- API Documentation
- Sales and fee related APIs
- Network management related APIs
- Account management related APIs
- Instance Management APIs
- Data security encryption related APIs
- Parameter configuration related APIs
- Log management related APIs
- Extended Event APIs
- Read only instance management related APIs
- Data migration (cold standby migration) related APIs
- Data migration (DTS old version) related APIs
- Making API Requests
- Database APIs
- Other APIs
- FAQs
- Service Agreement
- Performance Evaluation
Creating Admin Account
Last updated: 2024-11-27 09:41:05
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.
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. |
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No