Question: You created a Windows EC2 instance with a public IP address and installed SQL Server. When attempting to connect to SQL Server from SQL Server Enterprise Manager on your local computer, the Windows EC2 instance is unable to establish a connection to the server. What is the first thing you should check?

  1. Check the routing tables for the VPC.
  2. Verify that the assigned security groups allow TCP port 1433 traffic from your current IP address.
  3. Check the policies within Windows Firewall.
  4. Verify that you are connecting to the instance using a user that is not sa.

Answer: The correct answer of the above question is Option B:Verify that the assigned security groups allow TCP port 1433 traffic from your current IP address.