Unable to connect on AWS - RDS DB : SQL Server 2012 Express

sql-server amazon-web-services amazon-rds
Philippe sillon picture Philippe sillon · Mar 7, 2016 · Viewed 8.1k times · Source

I'm new in AWS world. I have an issue to access to my instance of Microsoft SQL Server 2012 Express (11.00.5058) on RDS (US-East-1a).

When I have created DB instance, I was able to access to it, create some tables, transfer data, etc.. everything worked fine !

I didn't change anything and few hours after some inactivity, I try to access to the SQL Server instance by using Microsoft SQL Server Enterprise Manager but I was not able to connect to it anymore. I got following message:

Cannot connect to m3instance.cqbvdcpcgye3.us-east-1.rds.amazonaws.com,1433.

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - The wait operation timed out.) (Microsoft SQL Server, Error: 258)

Currently, instance appears as available, the security group is 'rds-launch-wizard (sg-be4afcc6)'.

I have try to connect to 1433 port on via Telnet and no success.

Instance name is m3instance.cqbvdcpcgye3.us-east-1.rds.amazonaws.com.

Do you have any idea what append ?

Thank a lot for your help.

UPDATED

Telnet command return this :

telnet m3instance.cqbvdcpcgye3.us-east-1.rds.amazonaws.com 1433

Connecting To m3instance.cqbvdcpcgye3.us-east-1.rds.amazonaws.com...
Could not open connection to the host, on port 1433: Connect failed

DB settings :

enter image description here

Security Group :

enter image description here enter image description here

VPC :

enter image description here

I have tried to connect by using my home connection, or coffee shop wifi without success. I didn't check what was my IP address at this moment but the strange thing is that I was able to connect to SQL server when I have created DB instance (create SQL table, transfer data, etc...) but after few hours (and without any change), I was not able to access to it.

May be if I add a new rule in security group / inbound rule like this,it will fix my issue : (i didn't try yet because I'm at work right now and we have firewall that block SQL access)

enter image description here

At this point, data are not sensitive and security is not a big issue.

Thank again for your help guys !!!

Answer

albaiti picture albaiti · Sep 5, 2016

This because maybe you choose the default group , so Edit Your Security Group And In (INBOUND) ADD RULE and allow connection from (ANYWHERE)

Related questions

How to backup Amazon RDS MS SQL Server database instance and restore locally

It is possible to create a backup of a database running on an Amazon RDS instance and restore it on a local machine using the standard Task -> Backup and Task -> Restore features within Microsoft SQL Server …

Read More
AWS RDS SQL Server unable to drop database

I tried to migrate a SQL Server database by Export Data-tier Application (.bacpac file) from an Amazon RDS instance to other, but import didn't succeed. So now I want to delete the database (which is empty), when I try to: …

Read More
How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More