Search code examples
sqlsql-serveramazon-web-servicesssmsamazon-rds

Cannot connect to RDS SQL Server Database using Management Studio

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: enter image description here

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: enter image description here

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:enter image description here

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.

Solution

  • In case anyone comes across this post looking for an answer, I just wanted to updated and make sure it's there if anyone needs it. The issue here turned out to be that I misunderstood the way "Publicly Accessible" works and set it to "Yes". Apparently it should have been set to "No". "Yes", however does work for the SQL Server Express version.