Appendix A: Setting Up SQL Server

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 >

Note: All web addresses given in this appendix are subject to change without notice. If Microsoft does change a web address, go to microsoft.com and search for the appropriate page.

MainBoss needs to use one of the versions of SQL Server specified in Microsoft SQL Server. If you already have this software installed at your site, MainBoss can use your existing installation. If you do not already have the software, you can purchase SQL Server from Microsoft or download the free version of SQL Server called SQL Express.

Before you look into obtaining any version of SQL Server, check to see if your company already has one installed. Many organizations may already have SQL Server in connection with some other software package.

There are several important options that should be specified when you install SQL Server. Therefore, make sure to follow the installation instructions given later in this appendix.

Server Hardware Requirements: The machine where SQL Server is running should meet the hardware requirements specified by Microsoft for the version of SQL Server you will be using. If you will be running MainBoss on the same computer, the machine should also meet the hardware requirements for MainBoss (stated in the main body of this guide). Since MainBoss and SQL Server will run simultaneously, the computer should have at least the amount of memory required by SQL Server plus the amount required by MainBoss.

The speed and available memory of the computer where SQL Server runs has a major effect on the overall speed of MainBoss. The effect is far greater than the speed of the computers where people actually run MainBoss.

Authentication within SQL Server: SQL Server offers two types of user authorization: SQL Authentication or Integrated Authentication. MainBoss requires Integrated Authentication. Mixed mode (accepting both authentication types) will work with MainBoss, but mixed mode is offered only for backward compatibility and Microsoft has deprecated it.