title: Connecting to SQL Server Express 2008 from a CE device
body: <p>I've developing a .NET Compact Framework app that needs to connect to SQL Server 2008 Express on another machine (Windows 7 x64).</p>
  
  <p>I'm tearing my hair out here - I can ping both ways from the device to the machine etc (although I lose some packets - presumably because at the moment the wireless router is miles away and we don't get much signal down here), but when I try and debug the application on the CE machine it always fails to find SQL Server.</p>
  
  <p>I've tried a variety of different connection strings with no joy.</p>
  
  <p>Here's the connection string I've got at the moment:</p>
  
  <pre><code>Data Source=10.0.0.12;Initial Catalog=EMS_Main;User ID=sa;Password=password;
  </code></pre>
  
  <p>Firewall is off.</p>
  
  <p>Thanks</p>