title: Why can I not connect to SQL Server using IP address, but works with server name?
body: <p>I have a server hosted in Amazon's cloud (EC2, AWS), where I have SQL Server installed.  With SSMS on the server, I can connect to the server instance using the Amazon server name and the SQL Server instance.  However when I use the IP address, I cannot connect.</p>
  
  <p>I have <em>Allow Remote Connections to Server</em> checked.</p>
  
  <p>Similarly, I am unable to connect to the SQL Server instance remotely.</p>
  
  <p>How can I resolve this?</p>