RDS - SQL Server Express - Connectivity

Question

Sorry, I've been working at this for the past 4 hours...

Created an RDS SQL Server Express DB via "Easy Create" options.

I modified config after to allow public access.

I'm not able to connect via Visual Studio Code "mssql for Visual Studio Code" extension.

"mssql: Error: Unable to connect using the connection information provided."

I'm also not able to ping, telnet et cetera the endpoint plus 1433 port. That bit doesn't completely surprise me - I've seen posts stating Amazon blocks that type of traffic.

Database is associated with default VPC which is wide open - no defaults changed.

Under "Security Groups" for database I see "Security group rules (2)" which leads me to believe there are 2 groups associated but the list below is completely blank and I cannot edit - add, delete, modify. My thought it those groups are hidden since it's managed.

Any ideas?

Thank you!

Accepted Answer

there could be multiple reasons for which you are not able to connect to the db instance.
If you are connecting from visualstudio running outside of aws (could be your laptop) you need to make sure that the instance is public

you can refer to https://aws.amazon.com/getting-started/hands-on/visualize-data-amazon-rds-sql-server-using-amazon-quicksight/ 
which explains about how to connect using ssms and you can ignore the quicksight connectivity.

RDS - SQL Server Express - Connectivity

相關內容