title: You can only create a user with a password in a contained database
body: <p>I am using  a contained database, after creating the database I attempted to create a user but I got the error:</p>
  
  <blockquote>
    <p>You can only create a user with a password in a contained database</p>
  </blockquote>
  
  <p>My code is:</p>
  
  <pre><code>sp_configure 'show advanced options',1
  GO
  RECONFIGURE WITH OVERRIDE
  GO
  sp_configure 'contained database authentication', 1
  GO
  RECONFIGURE WITH OVERRIDE
  GO
  </code></pre>
  
  
  
  <pre><code>CREATE DATABASE [MyDb]
  CONTAINMENT = PARTIAL
  ON PRIMARY
  ( NAME = N'My', FILENAME = N'C:\My.mdf')
  LOG ON
  ( NAME = N'My_log', FILENAME =N'C:\My_log.ldf')
  </code></pre>
  
  
  
  <pre><code>CREATE USER MyUser
  WITH PASSWORD = 'pass@123';
  GO
  </code></pre>