title: Cannot create sql  server database user correctly
body: <p>I'm trying to create a user in a SQL Server database with SQL authentication. That's what I did:  </p>
  
  <ol>
  <li>Created database named <code>testDb</code> (with default parameters)  </li>
  <li><p>ran script </p>
  
  <pre><code>CREATE LOGIN test 
      WITH PASSWORD = 'test';
  USE testDb;
  CREATE USER test FOR LOGIN test;
  GO 
  </code></pre></li>
  <li><p>Ensured user <code>test</code> appeared in <code>Databases\testDb\Security</code> (in Management Studio)  </p></li>
  <li>Tried to connect to the server with Management Studio using user <code>test</code>  </li>
  <li>Got 18456 error.    </li>
  </ol>
  
  <p>I'm using SQL Server 2008 Developer Edition. The OS is Windows 7 Ultimate. What am I doing wrong?</p>