Overview
This document describes how to connect to a TencentDB for SQL Server instance through SQL Server Management Studio (SSMS) on a Windows CVM instance and run a simple query.
Note:
The CVM and TencentDB instances are better to be under the same account and in the same VPC in the same region.
CVM and TencentDB instances in the same VPC in different AZs in the same region can directly interconnect through private IPs.
CVM and TencentDB instances in different regions or VPCs or under different accounts can interconnect through Peering Connection or CCN. Directions
1. Log in to the TencentDB for SQL Server console, click an instance ID to enter the instance details page, and view the private IP and port number of the instance, which will be used for connecting to the TencentDB instance.
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 by comma. For example, if the private IP of the instance is 10.10.10.10
and the port number is 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. 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:
Run the query. SSMS returns the TencentDB for SQL Server instance.
Was this page helpful?