Cannot connect to RDS SQL Server Database using Management Studio

For inbound rules, go to the VPC Security group of your database instance

In Inbound tab click modify

In column source change ip 0.0.0.0 by your IP by "My IP" or "Anywhere"


In my case I opened the VPC Security group associated with my database

enter image description here

In the EC2 Security groups dashboard I selected Edit Inbound Rules from the actions dropdown and chose edit inbound rules.

At first, I looked at the inbound rules and thought everything was OK since this was the current setup enter image description here

After all - if it was allowing all traffic, then what could possibly be wrong?

On a whim I added a rule for TCP port 1433. Ending up with this simple setup

enter image description here

Then it immediately started working for me.


Make sure it is publicly accessible, there is a radio button you have to check to make it publicly accessible.enter image description here

Also add MS SQL inbound rule in inbound tab.After making the change wait for sometime so that the settings are updated in the instance.


In my experience this was counter-intuitive. With the options I selected, all ports and IPs seemed to be open, but after editing the inbound and outbound rules in the security group to have MS SQL for anywhere, I was able to connect.

Tags:

Sql

Sql Server

Amazon Web Services

Ssms

Amazon Rds

Related

How to take UIImage of AVCaptureVideoPreviewLayer instead of AVCapturePhotoOutput capture Swift's JSONDecoder with multiple date formats in a JSON string? Include all navigation properties using Reflection in generic repository using EF Core Visual Studio 2017 bin\roslyn files locked during build The page will strangely refresh when I click the button an expression tree lambda may not contain a null propagating operator @PostConstruct annotation and spring lifecycle How do I fix maven error The JAVA_HOME environment variable is not defined correctly? What's the difference between git stash save and git stash push? Create nested object from multiple string paths Position fixed on chrome mobile causing element to move on scroll up/down Java: How many Sundays fell on the first of the month during the twentieth century (1 Jan 1901 to 31 Dec 2000)?

Recent Posts