title: Keep getting "Login failed for user IIS APPPOOL\DefaultAppPool" no matter what I do
body: <p>I'm trying to give an ASP NET App access to a database (These are test only not production).</p>
  
  <p>It's the first time I try it in this network, and I haven't done it with VS2012, SQL Server 2012 Express, Windows 7 before</p>
  
  <p>What I have done:</p>
  
  <ul>
  <li><strong>I upgraded my Sql Server 2012 Express</strong> since what VS2012 first installs is a version that doesn't allow access from IIS</li>
  <li>I found that I had to configure SQL Server 2012 Express to accept <strong>remote connections</strong>, then I followed a good blog I found <a href="http://www.linglom.com/it-support/enable-remote-connection-on-sql-server-2012-express/" rel="noreferrer"> here</a></li>
  <li>In SSME 2012, I added a new login for all databases <strong>NT AUTHORITY\NETWORKSERVICE</strong> (I browsed it and found "Servicio de red" which stands for NETWORKSERVICE, so it is actually <strong>NT AUTHORITY\Servicio de red</strong>)</li>
  <li>I set dbo as the default schema for this login</li>
  <li>Under login properties, in <strong>User Mappings</strong>, I checked my Database (which I named MiniNorthwind) and then checked db_datareader and db_datawriter in Database Role Membership for MiniNorthwind</li>
  <li>In Internet Information Services Manager I checked that the DefaultAppPool Identity was <strong>ApplicationPoolIdentity</strong> (It was the default setting)</li>
  </ul>
  
  <p>But I still get an error saying that <strong>Login failed for user IIS APPPOOL\DefaultAppPool</strong>, if I change the DefaultAppPool identity to NetworkService, then the error changes to <strong>Login failed for user NT AUTHORITY\Servicio de red</strong></p>
  
  <p>I don't know what else to do. Please, need help here.</p>
  
  <p>Rafael</p>