title: How to set user Windows password in SQL Server
body: <p>I am using SSMS to interact with a database I have locally on my PC. I also have a software to create reports about data in the database, but first of all I have to connect the software to the SQL Server database.</p>
  
  <p>I'm logging into the database using Windows authentication (credentials <code>WindowsDomain\username</code>) which is my PC name and Windows username. At the beginning I didn't set a password and it connected successfully.</p>
  
  <p>But to connect the software to the database, I have to fill in different fields such as Host Name, Port Number, Database Name, User, Password. I can't leave empty the Password field even if I don't have one, so I need to set a password for my Windows username : OK easy, I just have to set the password account in the Control Panel..</p>
  
  <p>I restart my PC and check if I need to fill the password, now, in SQL Server.. But it still connects without any password, the software does not connect the database with that password, and in SQL Server I can't solve it with a query (alter login on my username), error : </p>
  
  <blockquote>
    <p>Cannot use parameter PASSWORD for a Windows login.</p>
  </blockquote>
  
  <p>How can I set a password for this user name ? Or maybe to create a new one with SQL Server authentication or Windows authentication, it's the same for me...</p>