title: Troubleshooting SQL Server connection issues
body: <p>I'm relatively inexperienced at SQL Server, but am trying to troubleshoot some of the (non-SQL Server-related) logic and UI issues in a Delphi app someone else wrote which uses it. Currently trying to get the dev environment functioning.</p>
  
  <p>Here's the environment:</p>
  
  <p><strong>Dev machine:</strong> Virtual machine (VMWare) running Windows XP, using Bridged Networking. Can connect to folders/files on the server machine fine. I have an old version of SQL Server 2005 Express installed on this machine. I can connect to it okay from this same machine, using the SQL Server Management Studio Express, and  also via my Delphi components (ADO, can read/write table data to a grid, etc).</p>
  
  <p><strong>"Server"</strong> (aka S1): Actually just a Windows XP workstation. I put a bone stock SQL Server 2008 install on it. Since installing I have enabled Protocols for SQLEXPRESS -> Name Pipes, and TCP/IP, using the Configuration Manager, and restarted the SQL Server service.  The  SQL Server is set to use Windows NT authorization. This is the machine and SQL Server instance I need to connect to from the Dev machine.</p>
  
  <p>I can connect to the S1 SQL Server instance from the same machine using the Management Studio, but I cannot connect to it from the Dev box, Using either the 2005 Management Studio (which I'm not even sure is supposed to be possible given different versions) or the Delphi components string builder (TADOConnection using OLDEDB Provider for SQL Server). When I try the latter, the S1 SQL Server instance does not show up in the drop-down list, and if I manually type in S1\SQLEXPRESS, using either Windows NT Integrated Security or a Specified Username and Password, I get the following error:</p>
  
  <pre><code>---------------------------
  Microsoft Data Link Error
  ---------------------------
  [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
  ---------------------------
  OK   
  ---------------------------
  </code></pre>
  
  <p>This is a peer-to-peer network; no domain controller, etc. Username and passwords on the two machines are identical.</p>
  
  <p>How do I go about troubleshooting this?</p>
  
  <p>================================================<br>
  Using Andomar's pointer and the link I commented with below (which explains the Surface Area Configuration tool went away in SQL Server 2008), I've gotten to this in the S1 machine's SQL Server Management Studio settings, and set it as follows, but still no non-local connection ability.  What am I missing?</p>
  
  <p><a href="http://img192.imageshack.us/img192/8784/sacsettings.jpg" rel="nofollow noreferrer">SAC settings http://img192.imageshack.us/img192/8784/sacsettings.jpg</a></p>
  
  <p><a href="http://img38.imageshack.us/img38/457/sacsettings2.jpg" rel="nofollow noreferrer">SAC Settings close up http://img38.imageshack.us/img38/457/sacsettings2.jpg</a></p>