Testing Whether a User Has Access to SQL Server and 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.2.
For the latest version of this help file can be found here.

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

In order to access the MainBoss database from a Remote machine, a user must have appropriate permissions with SQL Server. The following procedure can be used to determine if a user has these permissions. (In order for this to work, the user who performs the test must have administrator privileges, i.e. be part of the Administrators group.)

  1. Login to the Remote machine in question under the login name you want to test.
  2. Open the Windows control panel.
In Windows 7 and 8, click System and Security, then Administrative Tools.
  • In Windows Vista and Server 2008, click Administrative Tools directly from the control panel.
    1. In the Administrative Tools menu, click Data Sources (ODBC) or ODBC Data Sources, whichever appears in the list.
    2. In the resulting window (ODBC Data Source Administrator), go to the System DSN section.
    3. Click Add.
    4. In the list, click SQL Server (typically near the bottom of the list), then click Finish.
    5. Windows opens a box where you can create a new data source for SQL Server. For Name, specify anything (e.g. TEST). In Server, pick the SQL Server where MainBoss resides.
    6. Click Next, then click Next again.
    7. Checkmark Change the default database to:. In the resulting drop-down list, pick the name of the MainBoss database on the SQL Server system.
    8. Click Next, then click Finish.
    9. Click Test Data Source.

    You should end up with a window saying that the test completed successfully.

    Once you get the message that the test completed successfully, you can click OK twice. This gets you back to the ODBC System Administrator window. At this point, you can Remove the data source that you just added. This doesn't do anything to the MainBoss database, it just removes the entry from the list. Click OK to finish up.

    Remember, if you get an error during this process, use Google to look up the error message: you may get useful tips about what went wrong.

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