Registering New Users with MainBoss

This help file applies to an out-of-date version of MainBoss.
The most recent version of MainBoss is MainBoss 4.2.3.
For the latest version of this help file can be found here.

< Previous section  |  Table of Contents  |  Index  |  Next section >

To authorize someone to access a particular MainBoss database, follow these steps:

  1. In the MainBoss control panel, go to Administration | Users:

  2. Click New. This opens a window where you can specify other users who can use the database.

  3. If your site uses trusted domains, go to the Advanced section and enter the user's domain name in "Scope". Otherwise, you can skip this step (and leave "Scope" blank).
  4. In the Details section, type the person's login name into "User Name".
  5. On the "Contact" line, click the second drop-down arrow. From the resulting menu, click New Contact.
  6. Fill in contact information for the user whose record you are creating. When you're done, click Save & Close to save the contact information and close the window.
  7. Back in the user record, click Save & New.
  8. Repeat Steps 3-7 for each person who'll be using MainBoss. Click Close or Save & Close to return to the previous window. The window will show the users you have authorized.

Your MainBoss license restricts how many entries there may be in the Users table.

SQL Server Security: By default, the option MainBoss manages SQL Security is checkmarked in the Defaults for User section of Administration | Users. If you add a new user when this option is in effect, MainBoss attempts to give the user appropriate SQL Server permissions on the MainBoss database. This will only work if you have SQL Server Administration privileges on the SQL Server that manages MainBoss.

If you don't have SQL Server Administration privileges, you must turn off MainBoss manages SQL Security. Otherwise, you'll get an error when you try to add new users. If MainBoss manages SQL Security is turned off, new users must be separately authorized within SQL Server using Microsoft's SQL Server Management Studio. For more information, see Authorizing Users in SQL Server.

In order to add new users within MainBoss, you must have the MainBoss Administration security role, or else you must have Windows Administrator privileges and start MainBoss with "Run as administrator".

Local Users vs. Domain Users: If your site uses domains, it's possible for the same login name to exist both inside and outside of a domain. For example, suppose you have a domain named OurDomain that contains a user named jsmith. It's possible for the SQL Server computer to have a local login name jsmith as well as the domain version (typically written OurDomain\jsmith).

If both versions of jsmith need to use MainBoss, they must both be in the MainBoss Users table. For the domain jsmith, set "Scope" to the domain name (OurDomain). For the non-domain jsmith, set "Scope" to the name of the computer. (This can be determined from the computer's Control Panel by going to System.) The non-domain jsmith will only be able to use SQL Server if the Server machine also has a local non-domain jsmith with the same password, and if the Server computer has been appropriately set up for network file-sharing. Also the non-domain jsmith must have a SQL Login recorded with SQL Server, which MainBoss may or may not create automatically (depending on various options). If you need to create a SQL Login by hand, see Authorizing Users in SQL Server.

< Previous section  |  Table of Contents  |  Index  |  Next section >