Created RDS database, Cannot connect via Microsoft SQL Server Studio

0

Hi,
I am new to AWS. Just created new account and created my first SQL server Database (RDS) according to the tutorial.

The database is up and running, but I cannot connect to it via microsoft sql server management studio.
I got the following error:
"A network-related or instance-specific error occurred while establishing a connection to SQL srever. The server was not found or was not accessible...... Error: 53)

I tried to ping the endpoint in command window, but get timeout response.

What could be the issue? Is it because the "outbound security group"? do I need to set up a outbound rule? Or it is some firewall block the connection?

Please help. Thanks so much

dhminer
asked 5 years ago963 views
1 Answer
0

Hi,
Are you following the Tutorial at this link?
https://aws.amazon.com/getting-started/tutorials/create-microsoft-sql-db/

My initial guess is that you may have skipped Step e. "Configure advanced settings", where you may have left the 'Public accessiblity' setting at the default "No", instead of setting it to "Yes".

To start troubleshooting, please answer the questions below..

- Is your Microsoft SQL server Studio running on a computer at home/work (as opposed to in an EC2 instance in the same VPC)?
- Got to Services->RDS, Click on Databases, then click on the link for your SQL Server DB identifier.
  Under Security, does Public accessibility say 'Yes'?
-  In the same section, click on the the VPC security groups link. After the Security Group is displayed, click on Inbound tab.  Do you see an entry with:
MS SQL   TCP     1433     0.0.0.0/0

Note: you do NOT need to add an Outbound rule for your Security group. Security groups are stateful, meaning that if you allow the connection to be established coming into the server, the Security Group will allow the traffic to flow back to the originating client without an explicit Security Group Outbound Rule.
-randy

answered 5 years ago

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