title: Configuring ASP.NET MVC app's IIS 7.5 Application Pool identity as login on SQL Server 2008 R2
body: <p>I am trying to use IIS 7.5 Application Pool identity as login on SQL Server 2008 R2 so that my ASP.NET web app can connect to the database...</p>
  
  <p><a href="https://stackoverflow.com/questions/454497/iis7-sql-2008-and-asp-net-mvc-security/1031774#1031774">Using this approach</a> worked fine on my local dev machine (IIS 7.5 and SQL Server 2008 R2 on same machine).</p>
  
  <p>However, when I try to set up the same on production (IIS and SQL servers are separate) I am unable to add "IIS APPPOOL\MyAppAppPool" login to SQL Server 2008 R2.</p>
  
  <p>Notice that in either case you cannot use "Browse..." when creating a login in SQL Server since "IIS APPPOOL\MyAppAppPool" user identity is dynamic (or "special")...</p>
  
  <p>Any ideas?</p>
  
  <p><strong>Update:</strong></p>
  
  <p>For more info on Application Pool Identities <a href="http://learn.iis.net/page.aspx/624/application-pool-identities/" rel="nofollow noreferrer">see here</a>.</p>
  
  <p>From article:</p>
  
  <blockquote>
    <p>Whenever a new Application Pool is
    created, the IIS management process
    creates a security identifier (SID)
    that represents the name of the
    Application Pool itself. For example,
    if you create an Application Pool with
    the name "MyNewAppPool," a security
    identifier with the name
    "MyNewAppPool" is created in the
    Windows Security system. From this
    point on, resources can be secured by
    using this identity. However, the
    identity is not a real user account;
    it will not show up as a user in the
    Windows User Management Console.</p>
  </blockquote>