By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

RDS - SQL Server Express - Connectivity

0

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!

Topics
DatabaseMigration & ModernizationAnalyticsAWS Well-Architected FrameworkNetworking & Content Delivery
Tags
Microsoft SQL ServerAmazon Relational Database ServiceDatabaseSecuritySecurity Group
Language
English
Axolotl
asked 2 years ago380 views
1 Answer
1
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.

AWS
subhashr
answered 2 years ago
  • Axolotl
    2 years ago

    Thanks so much for your help and pointing out that page. My issue was in the inbound messages per step J - adding an inbound rule for traffic from my machine. I mistakenly thought the existing rule allowed all traffic regardless of source - it was only from an existing Security Group.

    Thank you again!

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content