title: Logon,Unknown,Login failed for user. Reason: Failed to open the explicitly specified database. [CLIENT: <local machine>]
body: <p>Hi i get the following error message when trying to connect to DB in sql server management studio 2008</p>
  
  <pre><code>07/23/2014 09:52:14,Logon,Unknown,Login failed for user 'usernamehere'. Reason: Failed to      open the explicitly specified database. [CLIENT: &lt;local machine&gt;]
  07/23/2014 09:52:14,Logon,Unknown,Error: 18456&lt;c/&gt; Severity: 14&lt;c/&gt; State: 38.
  </code></pre>
  
  <p>Running IIS 7.5 App Pool 4.0</p>
  
  <p>Ive created a user mapped it to the database selected dboOwner yet it still doesn't connect. I've also set the database option "Auto Close" to false. It was set to true before. The same username and password allows me to connect to the database through Management Studio 2008.</p>
  
  <pre><code>Line 2:      if (!WebSecurity.Initialized)
  Line 3:      {
  Line 4:          WebSecurity.InitializeDatabaseConnection("DefaultConnection", "Users",
  Line 5:  
  Line 6:  "UserId", "UserName", autoCreateTables: true);
  
  Source File: e:\AdminPanel\_AppStart.cshtml    Line: 4 
  </code></pre>