Procedure to Add An SQL Server Login

  1. Start Enterprise Manager
  2. Click + to expand SQL Server Group
  3. Click + to expand your server group
  4. Click + to expand Security
  5. Right click Logins
  6. Click New Logins
  7. Key your new SQL Server Login in Name

    8. Click SQL Server authentication radio button

    Key your password in Password box

    Choose your default database in Database drop down box

    Choose English in Language drop down box

    Click OK

  8. Rekey your password in Confirm New Password box

    9. Click OK

  9. Click OK in Error box to continue
  10. Double click Logins
  11. Double click your new SQL Server login
  12. Click Database Access tab
  13. Click check boxes to permit access to databases
  14. Click Apply button
  15. Click OK