Allowing MainBoss Service to Access the MainBoss Database

This help file applies to an out-of-date version of MainBoss.
The most recent version of MainBoss is MainBoss 4.2.4.
This help file does not exist in MainBoss 4.2.4, but the index for that version can be found here.

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

MainBoss Service needs to access the MainBoss database. This means that MainBoss Service's login name must be granted SQL Server permissions on the database. To grant these permissions, you must be logged in under a login name that has Windows Administrator privileges and SQL Server Administrator permissions on the instance of SQL Server that manages the MainBoss database.

If you are running MainBoss Service under a system account like Network Service, the account may already have appropriate SQL Server permissions. If so, you can skip this step. Otherwise, add a SQL Server login for the account under which you are running MainBoss Service, by following these steps:

  1. Login to Windows under a login name that has SQL Server Administration privileges.
  2. Start SQL Service Management Studio and connect with the instance of SQL Server that manages the MainBoss database.
  3. In the left hand panel of Management Studio, expand Security.
  4. Right-click on Logins, and click New Login.
  5. In "Login name", enter the login name under which you will run MainBoss Service. (Specify the full login name in the format DOMAIN\USERNAME. If you aren't sure of the correct format, use the Search button to find the right name.)
  6. In "Default database", select the name of the MainBoss database.
  7. In the Select a page panel, click Server Roles.
  8. In the list of server roles, make sure that public is checkmarked.
  9. In the Select a page panel, click User Mapping.
  10. In the list of databases under Users mapped to this login, click the name of the MainBoss database.
  11. In the bottom panel of the window (Database role membership for:), checkmark public and MainBoss.
  12. Click OK.

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