title: Cannot connect to RDS SQL Server Database using Management Studio
body: <p>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:
  <a href="https://i.stack.imgur.com/d9IYK.png" rel="noreferrer"><img src="https://i.stack.imgur.com/d9IYK.png" alt="enter image description here" /></a></p>
  <p>Here is the text of the error:</p>
  <p>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)</p>
  <p>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.</p>
  <p>Here you can see the details:
  <a href="https://i.stack.imgur.com/wB0KL.png" rel="noreferrer"><img src="https://i.stack.imgur.com/wB0KL.png" alt="enter image description here" /></a></p>
  <p>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</p>
  <p>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:<a href="https://i.stack.imgur.com/TE8yZ.png" rel="noreferrer"><img src="https://i.stack.imgur.com/TE8yZ.png" alt="enter image description here" /></a></p>
  <p>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.</p>
  <p>Thanks.</p>