I’ve worked with AWS for a long time now but it always slips my mind on how to do some of the simplest things. I hope this saves everyone else as much time as it saves me
Connect To Amazon SQL Server RDS Database
When you first create a SQL Server RDS you’ll get an endpoint such as:
arcadianmssql.ceyqa4mvqwxt.ap-southeast-2.rds.amazonaws.com:1433
Use this as the server name and then use the admin username and password you setup on creation to login. If it doesn’t work at first you may need to set the security settings to allow external connections.
Create a Amazon SQL Server RDS Database
This can be done in Microsoft SQL [...]