1 Answer
0
Hi.
Lightsail has a VPC peering feature.
However, you can only peer with the default VPC.
If you have an RDS resource other than the default VPC, you can place the NLB in front of the RDS and use the endpoint service to establish a connection route from the default VPC to the RDS with an IP address target.
https://dev.classmethod.jp/articles/nlb-bastion-for-rds/
I have successfully connected to Lightsail-> Endpoint on Default VPC-> NLB-> RDS with this configuration.
Relevant questions
Lightsail Windows Server 2019
asked 6 months agoHow Instances in Private subnet can connect to Internet with NAT Instance
Accepted Answerasked 2 months agoHow can Ec2 Instance in private subnet access internet via vpc endpoint?
Accepted Answerasked 3 months agoLost access to Windows server
asked 2 years agoCan't connect to MySQL db from Lightsail instance. MY-010055 warning in logs.
asked 9 months agoPlacing a Bastion in a Private Isolated Subnet
asked 8 months agoUnable to connect to EC2 instance in private Subnet
asked a year agoUnable to connect to EC2 instance in private Subnet
asked 2 years agoConnect Lightsail instance to AWS instance in a private subnet
asked 5 months agoEC2 instance in private subnet shows IPv4 address of NAT instance
asked 3 years ago
Thanks for your response. Will this configuration also work with connecting to MSSQL DB?
Yes. You can also connect with MSSQL.
Only the port number is different.
I tried your scenario and put it together in an article. I verified it with MySQL, but it should work with MSSQL as well.
https://dev.classmethod.jp/articles/lightsail-connect-vpc-rds/