title: Unable to access an instance of SQL Server 2008 R2 remotely
body: <p>A very mysterious problem coming up :P</p>
  
  <p>I have a server configured with a static IP. I have installed SQL Server 2008 R2 with additional instance (ITAPP). Now When I use the IP to access the SQL Server following things happens:</p>
  
  <p>Client Machine:</p>
  
  <pre><code>sqlcmd -S XXX.XXX.XXX.XXX -U sa -P mypass
  </code></pre>
  
  <p>Connected Successfully....</p>
  
  <p>But when I use:</p>
  
  <pre><code>sqlcmd -S XXX.XXX.XXX.XXX\ITAPP -U sa -P mypass
  </code></pre>
  
  <blockquote>
    <p>HResult 0xFFFFFFFF, Level 16, State 1 SQL Network Interfaces: Error
    Locating Server/Instance Specified [xFFFFFFFF].</p>
    
    <p>Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred
    while establishing a connection to the server.</p>
    
    <p>When connecting to SQL Server 2005, this failure may be caused by the
    fact that under the default settings SQL Server does not allow remote
    connections.. </p>
    
    <p>Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.</p>
  </blockquote>
  
  <p>Even on the same machine (where the SQL Server is installed) using SQL Server Management Studio. I have put off my firewall on both machines, even allow all the protocols for ITAPP (Shared Memory, Named Pipes, TCP/IP), also set <code>Allow Remote connection</code> to true.</p>
  
  <p>One thing more when I use <code>127.0.0.1\SQLITRAX</code> to connect on server machine it connects Immediately.</p>
  
  <p>Please help me out from this mess :)</p>