RDS

Products

RDS

Documentation > Products > RDS > Connect to SQL Server from Client

Connection Instance of Client to JCS for SQL Server

Microsoft Client Download Address

Download SQL Server Management Studio (SSMS) first, official address:> http://download.microsoft.com/download/0/9/9/099E0C83-072B-42A5-83A0-9BB3D2E6E2A3/SQLManagementStudio_x64_CHS.exe

Connection Method for Disabled Internet Access

It is recommended to disable the internet access in production environment for database security. Users can connect to the JCS for SQL Server database locally through the port forwarding function of SSH2 if to temporarily access the database locally through the client, and specific steps are as follows: (take SecureCRT as an example)

  1. Prepare a VM with an EIP and Linux operating system, such as 64-bit CentOS 7.3. The machine shares one VPC and subnet with cloud data.
  2. Choose "SSH2" for the connection protocol of SecureCRT and configure the IP of VM in public network

Connection Instance 1

  1. Select Port Forwarding and click Add.

Connection Instance 2

  1. Configure forwarding parameters

Connection Instance 3

  1. Connect the public network VM with SecureCRT

Connection Instance 4

  1. Run SSMS locally and connect to the database

Connection Instance 5

  1. Input connection information Input the local IP "127.0. 0.1" and the local port 6000 configured in the server name column, separated by a comma;

Selects SQL Server Authentication for authentication

Connection Instance 6

  1. Database can be connected for operation after authentication succeed.

Connection Instance 7

Update Time:2019-07-01 17:59:25