Adding Users To Boss

For all BOSS users , it is no longer necessary to add users to the SQL database. Adding new users through the Admin Module will now automatically prompt you to add the user to the SQL Database. Just follow the steps below:
  • Load the Admin module.
  • Select the BOSS Users tab.
  • To enter a new user, click the New button at the bottom of the screen and enter the user's information.
  • Once the user's information is entered, repeat for any additional users or exit the Admin module. The information you entered will be automatically saved.

  •  If an error occurs during this process, a warning message will tell you that the user has not been properly added to the SQL database. For more details on these warning messages, please see the list of error messages below. For more information on how users are added to the SQL database see: Adding Users To SQL Server
    • .

 

Error messages while adding new users to BOSS

Error Msg: Problem adding new user to the SQL database. Verify that you have proper rights to add user to data.

Situation: Trying to create or modify a BOSS user.

Solution: Only a user with administrative rights in SQL can create/modify a user. To verify these settings you will have to access the SQL Enterprise Manager (Start | Programs | Microsoft SQL Server | Enterprise Manager). From Enterprise Manager, expand until you get to the Security folder. Expand the Security folder and click the Logins icon. Find the SQL name of the user who is trying to add the new user, left click and select properties. Under the Server Roles, place a check in the box beside System Administrators. Return to the Admin module and modify adding the user.

 

Error Msg: Problem granting database access to the user name.

Situation: Adding a new USER to BOSS

Explanation: Similar to the SQL rights issue above, this relates directly to the to Server Roles granted the user that is creating the new login; however, in this case, the new login will be added to the SQL database because the user has only partial administrative rights defined in their login properties (i.e. Security Administrators can add logins but not grant access to databases).

Solution 1: There are two possible solutions to this problem. The first would be to edit the Server Roles of the user to include System Administrators rights. To avoid problems, delete the original login through the enterprise manager and then try to add the user again.

OR

Solution 2: The simpler route may be to finish creating the login manually through the SQL Enterprise Manager. First, verify to see if a corresponding login has been created, then follow the steps for adding users to SQL Server and fill in any missing data.

Back to FAQ Page

Copyright 2002 OQS Software Design Inc.