Creating a MS SQL database user (not windows authentication)

  1. Run SQL Server Management Studio.
  2. Connect to the SQL Server database where you would like to create a login.
  3. Open Security.
  4. Right-click on Logins & then New Login.
  5. If you would like to assign rights to a Windows account, select “Windows authentication“. If you would like to create an account that exists only in the database, select “SQL Server authentication“.
  6. Provide the login name in the text box. You may use the Browse button to select an existing account if you chose Windows authentication.
  7. Choose a Password for SQL Server authentication.
  8. Press OK to finish creating the account.