title: Can't log in with user of role db_owner
body: <p>I'm running the following script and receive no errors nor warnings. I also verify that the user actually has been created. When I click on it, I get to see the roles (the membership <em>db_owner</em> is checked).</p>
  
  <pre><code>create login normalLogin
    with password = 'normalpass',
    check_policy = off
  create login adminLogin
    with password = 'adminpass',
    check_policy = off
  
  create user common for login normalLogin;
  create user admin for login adminLogin;
  
  execute sp_addrolemember db_owner, admin
  </code></pre>
  
  <p>However, when I try to log in to the server using <em>admin</em> as user name and <em>adminpass</em> as password (SQL authorization), I get the error message telling me this.</p>
  
  <blockquote>
    <p>Login failed for user 'admin'. (Microsoft SQL Server, Error: 18456)</p>
  </blockquote>
  
  <p>Accessing the <a href="http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&amp;EvtSrc=MSSQLServer&amp;EvtID=18456&amp;LinkId=20476" rel="nofollow">helping link</a>, I get two feasible suggestions.</p>
  
  <ol>
  <li>Verify that SQL Server is configured in Mixed Authentication Mode.</li>
  <li>Verify that SQL Server login exists and that you have spelled it properly.</li>
  </ol>
  
  <p>I'm certain that (1) is correct (still, how can I re-check it?) so the suspicions fall on (2). Is the script above insufficient? I have the feeling that maybe the user on DB level isn't enough and that I need to create it on server level. Is it so? How can I script such an operation? I wish, of course, to keep the security tight and compartmentalized.</p>