I set up a VM server computer on AWS EC2 and got a SQL Express Server running on it on port 1433. I made sure to allow TCP/IP requests and allowed TCP port 1433 through the firewall along with UDP port 1434. I then created a second VM computer on AWS EC2 - same VPC, security group, and subnet - and installed SSMS.
I also made sure that to put the two computers in the same workgroup in windows, and made them discoverable.
I can connect to the SQL server I created via IP and port number (e.g. IPAddress\Hostname,1433) but I can't connect with just the hostname. Any ideas to what I'm missing here? I followed the documentation here to the letter and it doesn't seem to work.
I've also tried having the two EC2 VM computers ping each other by computer name and it doesn't work either.