I've taken these steps:
- Created an AWS account
- Spun up an MS SQL Server Express instance
- Added a security group for TCP 1433, my IP, prefix 32
- Added forwarding for my home firewall, for port 1433, to my dev computer
- Using SQL Management Studio on this machine, I attempt to connect to the server name shown in the AWS console, using the sa account name and password I specified earlier
I get "Cannot connect... network-related error... The parameter is incorrect".
On a LAN, my next thing to check would be that remote administration and TCP is enabled for the SQL instance. However, obviously any administration of a cloud machine will be remote, and the default parameter group has remote access turned on, so I presume this is set by default.
Connecting via RDP, the instance shows no SQL-related software installed. I suspect that the RDS instance needs to be associated with the Windows instance somehow, or perhaps if I want RDP access to the server underpinning an RDS, I need to install it on the server as an app, rather than using RDS.
These basic things have been surprisingly difficult to Google; it seems that the switch between EC2 and VDC has left conflicting sets of documentation floating out there.