0

I created a AWS RDS MS SQL Server database and obviously I want to connect to it from my local pc/laptop. I will share screenshots to show my network settings.

This is the error:

enter image description here

My connectivity & security details:

enter image description here

The Inbound rules when clicking on the VPC security groups related to this DB (I have added my own IP address:

enter image description here

I have no experience in networking & security, so it might be something I've missed.

What should I do to make it possible? I don't want public access to the database.

Update 1: added screenshots of my Network ACLs associated with the VPC that's related to the DB.

enter image description here

A. Gh
  • 631
  • 9
  • 24
  • Does your VPC have the [default network ACLs](https://docs.aws.amazon.com/vpc/latest/userguide/vpc-network-acls.html#default-network-acl). Also, see [troubleshooting](https://aws.amazon.com/premiumsupport/knowledge-center/rds-connectivity-instance-subnet-vpc/). – jarmod Dec 13 '22 at 12:08
  • @jarmod I have added a screenshot – A. Gh Dec 13 '22 at 12:14
  • Did you follow the troubleshooter? I see you modified inbound NACLS (unnecessarily because of rule 100). What about outbound NACLs? – jarmod Dec 13 '22 at 13:49
  • @jarmod I removed both modified rules, now it's back at default again. but it still doesn't work. – A. Gh Dec 13 '22 at 14:19

1 Answers1

0

I recommend checking that the subnets associated with the subnet group for this database are public.

As you mentioned, it is not safe to have a database publicly accessible. You can place it in a private subnet and only access it via a tunnel. Here is a link for that info. Hope it helps.

Mario
  • 46
  • 2