Adding Users To SQL Server

• To add users to SQL Server, start Enterprise Manager (Start | Programs | Microsoft SQL Server | Enterprise Manager). From Enterprise Manager, expand until you get to the Security folder. Also expand the Security folder and right-click the Logins icon. Select New Login. The following screen will appear:

• The following information should be entered on the General tab:
  Name: <User Name> the user name to be entered
  Authentication - select SQL Server authentication leaving the password blank
  Defaults - Database: OQS

• No information is entered on the Server Roles tab unless the user being entered is also going to administer SQL Server. If so:
  Server Roles - select System Administrators

• On the Database Access tab, the following information should be entered:
  Database access - select OQS
  Database roles for 'OQS': select OQS_Group

• Click on OK to save the new user.

Back to FAQ Page