title: Connect to an ASP.NET SQL express db with another C# Project
body: <p>I'm currently working on a project that has a front end ASP.NET website where users will submit "orders". I then need to access a specific table in this database with another C# windows form application that interacts with multiple Serial Ports.  (I'm not married to this idea, so if you think it's a better idea to have one website for both functions, i'm all ears)</p>
  
  <p>Anyway, this question is regarding the ability to have two connection strings (one from ASP.NET, and the other from a local program. - <strong>Both of which will be run on the same computer</strong>) </p>
  
  <p>On the C# end, i have a connection string of:</p>
  
  <pre><code>"AttachDbFilename=C:\\Users\\Jordan\\Documents\\Visual Studio 2012\\WebSites\\WebSite1\\App_Data\\MyxoData.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True;"
  </code></pre>
  
  <p>With this configuration, when one project is active, the other cannot access the database.</p>
  
  <blockquote>
    <p>Cannot open user default database. Login failed. Login failed for user 'CMYK-164\Jordan'.</p>
  </blockquote>
  
  <p>I have a feeling this is because I am using Integrated Security=true in my connection string and "User Instance=True" specifically only allows one user on a computer to log into a DB at a time...but I can't find anything that backs up my theory...or has a way around the problem.  </p>
  
  <p>Any suggestions would be much appreciated!</p>
  
  <p><strong>EDIT</strong></p>
  
  <p>The connection strings are not an issue. Both applications work perfectly when the other isn't active.  The issue here is establishing two concurrent connections to one database, from two different C# applications.</p>