title: Connection string for SQL Server Express on remote computer?
body: <p>I have a WinForms program I am creating for a friend of mine that uses a SQL Server Express database.  Locally, I can connect to my SQL Server Express fine and when I deploy the app to his computer, it works also. I'm having difficulty connecting to his SQL Server Express instance from my machine though (I'm trying to run the program in debug mode in vs2012 but connected to his database). The program uses Entity Framework in case that matters (I don't think it does).</p>
  
  <p>We've setup his firewall to allow my IP address to access his computer and his SQL Server... so I can log in via remote desktop and I can also connect using SSMS from my pc and see all the databases.... but why can't I connect using vs2012? I'm thinking it has something to do with the connection string but haven't found a working solution yet.  </p>
  
  <p>Here's what I have tried:</p>
  
  <p>Got these from <a href="http://www.connectionstrings.com/sql-server/" rel="nofollow">ConnectionStrings.com</a>:</p>
  
  <pre><code>Server=100.100.100.100\SQLExpress;Database=TestDB;User Id=UserID;Password=myPassword;
  
  DataSource=100.100.100.100\SQLExpress;Database=TestDB;User Id=UserID;Password=myPassword;
  </code></pre>
  
  <p>Obviously the IP address has changed for the purposes of this post.</p>
  
  <p>Any ideas?</p>