title: How to update a database user password in SQL Server 2012
body: <p>I am needing to update the password of one of the users in the database security folder in SQL Server 2012. Unfortunately, we do not have a DBA in-house and consequently needing some help. I've been told that I have sysadmin privileges on this SQL Server but I cannot find WHERE to update a user's password in the database.  When I googled this, msdn show me how to update a login in the SQL Server 2012 box but this user is NOT listed under the Security\Logins folder in this server but this user is only under the database\Security\Users folder.</p>
  <p>I had tried the <code>ALTER LOGIN username WITH PASSWORD = 'password';</code> command but I only got this error:</p>
  <blockquote>
  <p>Msg 15151, Level 16, State 1, Line 2</p>
  <p>Cannot alter the login 'ATM', because it does not exist or you do not have permission.</p>
  </blockquote>
  <p>Any help/direction would be appreciated.  Thanks.</p>