Creating and Connecting to a TencentDB for SQL Server Instance (from a Windows-based CVM Instance)

Last updated: 2020-03-10 13:39:55

    Operation Scenario

    This document describes how to connect to a TencentDB for SQL Server instance through SQL Server Management Studio (SSMS) in a Windows CVM instance and run a simple query.

    The CVM and TencentDB instances must be under the same account and in the same VPC in the same region.

    Directions

    1. On the TencentDB for SQL Server instance details page, view the private IP and port number of the instance, which will be used for connecting to the TencentDB instance.
    2. Log in to the Windows CVM instance. For more information, please see Getting Started with Windows CVM. This document uses Windows Server 2012 R2 Standard Edition (64-bit) as an example.
    3. Download and install SQL Server Management Studio (SSMS) in the Windows CVM instance. For more information on SSMS, please see Use SQL Server Management Studio.
    4. Start SSMS in the Windows CVM instance. On the Connect to server page, enter the relevant information to connect to TencentDB. Click Connect and wait a few minutes before SSMS connects to your database instance.
      • Server type: select "Database Engine".
      • Server name: enter the private IP and port number of the instance and separate them with a comma. For example, if the private IP and port number of the instance are 10.10.10.10:1433, then enter 10.10.10.10,1433 here.
      • Authentication: select "SQL Server Authentication".
      • Login and Password: enter the account name and password you configured when creating the instance account on the Account Management page.
    5. Once connected to the database, you can view the standard built-in system databases (master, model, msdb, and tempdb) of SQL Server.
    6. Now you can start creating your own databases and running queries for them. Select File > New > Query with Current Connection and type the following SQL query:
      select @@VERSION
      Run the query. SSMS will return the TencentDB for SQL Server instance.

    Was this page helpful?

    Was this page helpful?

    • Not at all
    • Not very helpful
    • Somewhat helpful
    • Very helpful
    • Extremely helpful
    Send Feedback
    Help