Скачать или смотреть AWS RDS Remote Connection

#aws #rds #sqlserver
Connecting to a remote instance of Microsoft SQL Server in cloud using Amazon AWS Relational Database Service (RDS) via JetBrains DataGrip on macOS..

Setup public access in the Virtual Private Cloud (VPC).

Addresses firewall issues caused by error:
[08S01] The TCP/IP connection to the host has failed. Error: "connect timed out. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.""

Address jdbc:sqlserver certificate trust issues caused by error:
[08S01] The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error PKIX path building failed: sun.security.provider.certpath. SunCertPathBuilderException: unable to find valid certification path to requested targetl"

Connecting your local development environment to a remote AWS RDS Microsoft SQL Server instance in the cloud:
   • Local Development with Remote AWS RDS  

0:00 Intro
0:18 Creating a MSSQL Server in RDS
2:36 Setup DataGrip remote connection
3:12 Firewall connection timeout errors
4:00 SSL Certificate trust errors
4:44 Using the Server from DataGrip