Release Notes
Product Announcements
Creating Account
This document describes how to create an account for a TencentDB for SQL Server instance in the console.
Prerequisites
Before creating an account, you need to understand the account types and permissions supported by TencentDB for SQL Server instances.
Overview
TencentDB for SQL Server supports creating and deleting accounts or modifying account permissions on the Account Management page in the console. It is prohibited to perform operations such as creating and deleting accounts or modifying account permissions through tools such as SSMS or NAVICAT. If the instance is connected outside the console (including but not limited to SSMS) to create and delete accounts or modify account permissions, the results may not be synchronized to the console and displayed.
Note:
The created account name and password will be used when connecting to TencentDB for SQL Server. Please store them properly.
The advanced permission account and ordinary account support the create login feature. To use this feature, submit a ticket for application.
Directions
1. Log in to the TencentDB for SQL Server console and click an Instance ID or Manage in the Operation column to enter the instance management page.
2. On the instance management page, select Manage Account > 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 can contain 1–50 characters, including letters, digits, and underscores (_), and should start with a letter. It should not contain any of 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) .It should also not contain any of the following sensitive characters: . | ## | ( ) | [ ] | , | ``` | ; | ' | " | \\ | -- | xp_cmdshell | sp_addsrvrolemember . |
Account Type | Select permissions of the account to be created based on the instance architecture. Two-node and multi-node Privileged account: An instance can have only one privileged account. Standard account. Designated account. Single Node Admin account: Each instance can only have one admin account. Note: Due to business risk and security 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. Privileged account: An instance can have only one privileged account. Standard account. Designated account. |
Database | Optional. You can set account permissions (read-write, read-only, or owner) for databases when creating an account, modifying permissions, or creating a database. Privileged accounts have owner permissions for all databases by default. When selecting databases for standard accounts and designated accounts, you can click Unauthorized Database to select all databases in one click, and then set permissions for each one under Authorized Database on the right side. You can click  |
New Password | The password should contain 8–32 characters, including 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. |
3. After creation, you can perform operations such as Set Permissions, Reset Password, and Delete Account in the account list.
Related Documentation
Related APIs
API | Description |
This API is designed for the creation of instance accounts. |
Help and Support
Was this page helpful?
You can also Contact sales or Submit a Ticket for help.
Help us improve! Rate your documentation experience in 5 mins.
Feedback