title: ASP.Net membership + sql server 2008
body: <p><strong>Update:</strong></p>
  
  <p>Forgot to mention that the app only breaks and shows that error when I try to login as asp.net membership user (sql membership provider), before that everything is fine and the app communicates with the sql just fine.</p>
  
  <p>I'm writing an asp.net app that's using asp.net sqlmembership and connecting to a SQL Server 2008 database remotely via VPN, </p>
  
  <p><strong>Connection string:</strong> </p>
  
  <pre><code>add name="MonoSqlServer" connectionString="Data Source=MONO;  
  Initial Catalog=SMSPortal;Integrated Security=SSPI;"
  </code></pre>
  
  <p>This works perfectly if I use the inbuilt <code>http</code> server that comes with visual studio, but if I deploy this to my local <code>IIS</code> (same machine as the inbuilt server) I get an exception:</p>
  
  <pre><code>Exception Details: System.Data.SqlClient.SqlException: Login failed.   
  The login is from an untrusted domain and cannot be used with Windows authentication.
  </code></pre>
  
  <p>What am I doing wrong?</p>