title: Diagnosing Connection to SQL Server
body: <p>I'm trying to create an ODBC connection to SQL Server, but when i do, i get error:</p>
  
  <pre><code>Connection failed:
  SQLState: '01000'
  SQL Server Error: 10060
  [Microsoft][ODBC_SQL Server Driver][TCP/IP Sockets] COnnectionOpen (Connect()).
  Connection failed:
  SQLState: '08001'
  SQL Server Error: 17
  [Microsoft][ODBC_SQL Server Driver][TCP/IP Sockets] SQL Server does not exist or access denied.
  </code></pre>
  
  <p>Here's what I've tried:</p>
  
  <ol>
  <li>not a firewall issue: tried with firewall on SQL Server turned off, and client turned off.  Also able to telnet  1433 from client and that works fine.</li>
  <li>not an access issue: I can login from many different computers, including the SQL Server itself using the account i'm using on client (using SQL Server authentication)</li>
  <li>i can ping the hostname and IP address. (i've tried both)</li>
  </ol>
  
  <p>The only thing i can think of is that the client computer is windows server 2003, and has various roles setup:</p>
  
  <ul>
  <li>File Server</li>
  <li>Application Server</li>
  <li>Terminal Server</li>
  <li>Domain Controller</li>
  <li>DNS Server</li>
  </ul>
  
  <p>I don't know why these services are setup, but for the time being i can't shut them off.  Would it be any of these, and if so, is there a way to disable any of the aspects of them, that might be blocking SQL.</p>
  
  <p>Any advise truly appreciated!</p>