title: SQL Server instance name with IP address
body: <p>I have a very strange situation happening and I'm hoping someone here knows why.</p>
  
  <p>I have TCP/IP enabled for all ports on the default port 1433.</p>
  
  <p>All tests are consistent with SQL Server Management Studio and my program. </p>
  
  <p>This works:</p>
  
  <ul>
  <li>ComputerName\InstanceName</li>
  <li>127.0.0.1</li>
  <li>127.0.0.1,1433</li>
  <li>192.168.1.100</li>
  <li>192.168.1.100,1433</li>
  </ul>
  
  <p>This does NOT work:</p>
  
  <ul>
  <li>127.0.0.1\InstanceName</li>
  </ul>
  
  <p>Note: I know it's not firewall related because I can telnet into 127.0.0.1 on port 1433.</p>
  
  <p>Note2: The connection string doesn't matter since the tests are consistent with Management Studio, but I'll give it anyway: <code>server={0};Integrated Security=True;Database=MyDatabase</code></p>
  
  <p>While reading MSDN it seems that you should be able to connect to an instance name via an IP address.  </p>
  
  <p>What's going on here?</p>