无法在AWS上连接-RDS DB:SQL Server 2012 Express [英] Unable to connect on AWS - RDS DB : SQL Server 2012 Express

问题描述

我是AWS世界的新手.我在访问RDS(US-East-1a)上的Microsoft SQL Server 2012 Express(11.00.5058)实例时遇到问题.

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 !

我没有进行任何更改，并且在闲置几个小时后，我尝试使用Microsoft SQL Server企业管理器访问SQL Server实例，但是无法再连接到它.我收到以下消息:

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:

无法连接到m3instance.cqbvdcpcgye3.us-east-1.rds.amazonaws.com，1433.

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

建立与SQL Server的连接时发生与网络相关或特定于实例的错误.服务器未找到或无法访问.验证实例名称正确，并且已将SQL Server配置为允许远程连接. (提供者:TCP提供程序，错误:0-等待操作超时.)(Microsoft SQL Server，错误:258)

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)

当前，实例显示为可用，安全组为"rds-launch-wizard(sg-be4afcc6)".

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

我尝试通过Telnet连接到1433端口，但没有成功.

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

实例名称为m3instance.cqbvdcpcgye3.us-east-1.rds.amazonaws.com.

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

您知道附加什么吗?

非常感谢您的帮助.

已更新

Telnet命令返回此:

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

数据库设置:

安全组:

VPC:

我尝试使用家庭连接或咖啡厅wifi进行连接，但均未成功.我现在没有检查我的IP地址是什么，但奇怪的是，在创建数据库实例(创建SQL表，传输数据等)后，我能够连接到SQL Server，但是几个小时之后(并且没有任何更改)，我无法访问它.

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.

如果在这样的安全组/入站规则中添加新规则，可能会解决我的问题:(我还没有尝试过，因为我现在正在工作，并且我们有阻止SQL访问的防火墙)

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)

在这一点上，数据不敏感，安全性不是大问题.

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

再次感谢您的帮助！！！

Thank again for your help guys !!!

推荐答案

这是因为您可能选择了默认组，所以请编辑安全组并在(INBOUND)添加规则并允许来自(ANYWHERE)的连接

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

这篇关于无法在AWS上连接-RDS DB:SQL Server 2012 Express的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！