title: New user and database on SQL Server
body: <p>I have SQL Server 2005, and I tried to create a new database with a user.</p>
  
  <p>I used these commands with sa user on master db:</p>
  
  <pre><code>CREATE LOGIN mobstat WITH PASSWORD = 'mobstat123';    
  CREATE USER mobstat FOR LOGIN mobstat;
  CREATE SCHEMA mobstat AUTHORIZATION mobstat;
  CREATE DATABASE mobstat COLLATE SQL_Hungarian_CP1250_CI_AS;
  EXEC sp_addrolemember N'db_owner', N'mobstat';
  </code></pre>
  
  <p>Every command executed well, but I cannot login with the new user.
  The error is:</p>
  
  <blockquote>
    <p>Cannot open database "mobstat" requested by the login. The login failed. </p>
  </blockquote>
  
  <p>I've tried to Google it, but no result yet.
  My client is DBeaver.</p>