Creating a SQL Server 2008 Database Account

  1. Open SQL Server Management Studio.
  2. Connect to the SQL Server database where you would like to create a login.
  3. Open the Security folder.
  4. Right-click on the Logins folder and select 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. If you chose SQL Server authentication, you must also provide a password (preferably a strong one!) in both the Password and Confirmation text boxes.
  8. Customize the default database and language for the account, if desired, using the drop-down boxes at the bottom of the window.
  9. Click OK to create the account.