Cannot connect to RDS SQL Server Database using Management Studio

Question

I created a SQL Server RDS Instance in AWS and it seems to be up and running, but if I try to connect to it using Management Studio I get this error:

Here is the text of the error:

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)

I initially tried with the default security group that was created with the instance, but when that didn't work I created a new security group and modified the instance to use it.

Here you can see the details:

I tried this connection setup to connect: Server Type: Database Engine Server Name: valuationdlsdev.ck1qvjqhglyg.us-west-2.rds.amazonaws.com,1433 Authentication: SQL Server Authentication Login: the Master User Login I created when creating the RDS Instance Password: the Master User Password I created when creating the RDS Instance

I was kinda at my wits end and so I changed the setting on the Security Group to All traffic just to see if that would work, so here are all the settings on the security group:

At this point I'm wondering if port 1433 is not open, because I feel like I've tried everything. Could someone please help me.

Thanks.

Answer 1

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

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.