SQL Server Connection Issue
0
I setup a new SQL Server instance from scratch, using the standard setup workflow . No additional configurations; pretty much out of the box setup with the endpoint publicly accessible. When attempting to connect to the database I get a MSFT Server Error: 53 (could not open connection). Makes zero sense. It's definitely setup to be accessible.
At a loss. Any thoughts?
1 Answer
- Newest
- Most votes
- Most comments
2
Check your default security group allows 1433 inbound from your IP address.
I say default as this is the SG assigned to your RDS instance in your screen shot.
Also make sure your RDS instance is in a Public subnet too.
Relevant content
- asked a year ago
- asked 2 years ago
AWS OFFICIALUpdated 6 months ago- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated a year ago
Yup. That was it. Thanks Gary.
Thanks for confirming this worked for you.
Sorry, but would you be so kind as to tell me which of these was the resolution for your connection issue?
And perhaps you be able to point me to where I might find more details on the setting changes that were required?
I'm a complete newbie here in AWS... just wanted to quick setup a SQL Server RDS for quick "proof of concept" of something but sadly I'm struggling to make a connection to it from outside. Well, that's not quite accurate. I HAVE successfully connected to it via SSMS but attempts at doing the same from appsmith have failed. Thus I suspect it has to do with allowing their IP's but from what I can tell I'm done that.
Many thanks!