我无法登录AWS RDS SQL Express服务器 [英] I can not log in to my AWS RDS SQL express server

问题描述

我已将我的初始设置设置为公共...然后我的安全组允许所有...然后我的acl设置为允许所有...但正好在它之下*所有拒绝就在那里.... fml



有什么想法吗？ Mysql连接但是sql \ posttgres只讨厌这个世界。我在这一点上迷失了。堆栈溢出只是打击了与此相关的每个问题。'



如果向实例添加策略，则非常不清楚。大多数人都说做某事，比如确保网络网关设置正确，但从不解释如何。



我尝试了什么： < br $> b $ b

创建Microsoft SQL Server数据库实例和连接到Microsoft SQL Server数据库实例上的数据库 - Amazon Relational Database Service [ ^ ]



尝试在SO上发帖...试过他们的论坛... 90％的解决方案都是群组安全策略...尝试跟随，一个正在运行的YouTube视频。这对他有用，但不适合我。尝试关闭我的防火墙，他们糟糕的故障排除指南。



有什么想法吗？

I have set my initial settings to public... then my security groups to allow all... then my acl is set to allow all... but right under it * all deny is right there.... fml

Any ideas? Mysql connects but sql\postgres just hate the world. im so lost at this point. stack overflow just hits downvote to EVERY question relating to this.'

It is EXTREMELY unclear how to "Add" policies to an instance. Most people say to do something, like make sure the network gateway is set correctly but never explain how.

What I have tried:

Creating a Microsoft SQL Server DB Instance and Connecting to a Database on a Microsoft SQL Server DB Instance - Amazon Relational Database Service[^]

tried posting on SO... tried their forums... 90% of the solutions are group security policy... tried following along, a working youtube video. that worked for him but not me. tried turning off my firewall, their awful troubleshooting guide.

Any ideas?

推荐答案

所以我' m假设您想要sql server而不是mysql / postgres基于你的问题标题说sql server express。



另外，我假设你的数据库是在RDS上但是你想从你的本地机器连接到它。



有些东西需要检查

• 检查以确保您的实例被标记为公共
  
  
  
  
  
  • In在控制台的RDS部分，选择所需的sql server rds实例，在展开的行上你应该看到左边的三个图标。单击文档上放大镜的中间图标
  • 您现在应该处理所选实例的配置详细信息。
  • 在安全和网络标题下查找公开访问的属性
  • 此可公开访问应标记为是，如果显示否则表示您的问题。

So I'm making an assumption you want sql server and not mysql/postgres based on the title of your question saying sql server express.

Also, I'm assuming your DB is on RDS but you are trying to connect to it from your local machine.

Some things to check

• Check to make sure your instance is marked as "public"
  
  
  
  • In the RDS portion of console, select the desired rds instance of sql server, on the expanded row you should see three icons on the left. Click the middle icon that looks like a magnifying glass over a document
  • You should now be on Configuration details for your chosen instance. Look for the attribute of "Publicly Accessible" under the Security and Network header
  • This "Publicly Accessible" should be marked as "Yes", if it says "No" there is your problem.

• 查找您的IP地址，您是否添加了最终的/ 32？例如，如果您的IP地址是172.9.9.123，则应将其添加到ACL中，如172.9.9.123/32
• 检查此ACL中列出的端口

• 尝试使用以下powershell脚本通过本地和EC2进行测试

[CmdletBinding()]
Param(
	[Parameter(Mandatory=

True）]
[ string ]

ServerName，

[参数（强制=

ServerName, [Parameter(Mandatory=

这篇关于我无法登录AWS RDS SQL Express服务器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！