Appendix A: Setting Up SQL Server

< 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 Advanced 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 Advanced on the same computer, the machine should also meet the hardware requirements for MainBoss Advanced (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 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.