I am new to AWS, so this is probably a newbie question. I have two instances, one for running a .NET Application in IIS 7.5, the other running MS SQL Server 2008 R2. I'd like the app server to get its data from the data server. I've put them both in the same security group and granted access to the standard 1433 SQL server port for the private IP addresses of both machines, as well as granted access to 1433 to the entire security group. I've also configured the "AllIPs" section to use 1433 rather than a dynamic port. I verified that TCP/IP connections as well as named pipes are permitted on the data server, and 1433 is open on both firewalls.
I've tried connecting to my data server from SSMS on the app server using the private IP as well as the private DNS name, both to no avail. In fact, I can't even ping them successfully.
What did I do wrong? Thanks!