tencent cloud

PrevNext

Feedback

search by keyword

Recent Pages

Documentation
TencentDB for SQL Server
    Documentation
    Download PDF

    Creating Account

    Last updated: 2024-11-04 11:55:29
    Download PDF
      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 and modifying account permissions on the Manage Account page in the console. Such operations cannot be performed in Microsoft SQL Server Management.
      Note:
      The created account name and password will be used when connecting to TencentDB for SQL Server. Please store them properly.

      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.
      Dual Node
      Privileged account: An instance can have only one privileged account.
      Standard account.
      Designated account.
      Single Node
      Admin account: An instance can have only one admin account.
      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.
      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.
      
      Contact Us

      Contact our sales team or business advisors to help your business.

      Contact Us
      Technical Support

      Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

      Submit a Ticket
      7x24 Phone Support
      Copyright © 2013-2024 Tencent Cloud. All Rights Reserved.
      Privacy PolicyLegalCookie Policy