title: SQL Server 2008 can't login with newly created user
body: <p>I'm using using Windows Vista and I'm having trouble logging in with a newly created user.</p>
  
  <ol>
  <li>I open SQL Server Management Studio. </li>
  <li>I create a new Login by right-clicking on Security->Logins.<br>
  Check: SQL Server Authentication<br>
  Login name: tester<br>
  Password: test<br>
  Click OK  </li>
  <li>I added this user to User Mapping to my database of choice.</li>
  <li>Click File -> Connect Object Explorer, select SQL Server Authentication and enter tester/test and click Connect.</li>
  </ol>
  
  <p>I get an error:</p>
  
  <pre><code>Login failed for user 'tester'. (Microsoft SQL Server, Error: 18456" 
  with Severity = 14 and State = 1.
  </code></pre>
  
  <p>What causes this error and how do I login with my user?</p>