title: Why won't SQL Server allow creation of a user with SQL Server Authentication?
body: <p>I've get a fresh install of SQL Server 2012 and do not want to use integrated security.  Instead I'd like to use SQL Server authentication, where I create logins in SQL server and assign passwords.  However, this option doesn't seem to be available (see screen snapshot below).  Every option available to me under &quot;User Type&quot; (other than those that aren't related to accounts at all) want me to map to existing Windows Domain accounts.</p>
  <p>In the old days, I'd specify a desired login name and be prompted for a password to go along with it, and I'd be done.  Now there's no option to specify a password--I'm forced to map my new login to an existing
  windows domain account.  Not what I want.  What am I missing here?  Thanks in advance.</p>
  <p>** edit ** New screen snapshots added after RB's comment.  I did indeed have an option disabled that would allow BOTH Windows and SQL Server authentication modes, but it's turned on now.  After doing so and restarting SQL Server, it is NOT making a difference:
  <a href="https://i.stack.imgur.com/zKKLX.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/zKKLX.jpg" alt="enter image description here" /></a></p>
  <p>Here is what I am presented with when I try to create a new user.  None of these options simply allow me to create a login and password in the context of SQL server (well, one allows creation of a login with no password at all... useless!)  All others are linked to existing Windows logins.  Ideas?</p>
  <p><a href="https://i.stack.imgur.com/DQQBP.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/DQQBP.jpg" alt="enter image description here" /></a></p>