Imported a SQL Server database, and it says login failed for a user that doesn't exist <p>I have a asp.net web application that I was hosting somewhere.</p> <p>I backed up the database and restored it locally.</p> <p>Now when I run the application, it says <code>myapp_user123011</code> doesn't exist.</p> <p>When looking at the security section for the db and the database server, I don't see that user anywhere.</p> <p>My <code>web.config</code> was changed to use the <code>sa</code> account.</p> <p>Not sure where this user could be referenced?</p> <p>I'm guessing this database user was imported into my database server (SQL Server 2008 R2) but for some reason isn't showing up in the user list in the security sections).</p> <p>How can I search and delete this user if this is the case?</p> <p>(Note: I have searched the entire solution for that username and it doesn't exist)</p>