SQL Server Installation

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 >

The default installation procedures for full versions of SQL Server are designed to let other computers connect with the Server computer. Therefore, their default options will generally work well with MainBoss.

However, the default installation procedure for SQL Express assumes that it will only be used on a single computer, without users on other computers trying to connect with SQL Server. If you intend to have users on other machines connect with SQL Express, you must change a number of default options during the installation. You must also set several configuration options after SQL Express is installed, as discussed later in this section. For more information, see SQL Express Considerations.

Overall, we believe customers will find it easier to use one of the full versions of SQL Server than the free SQL Express—full versions are simpler to install and to maintain (e.g. backing up the database). However, SQL Express is available at no charge and can be used successfully with MainBoss, especially by small maintenance departments.

SQL Server on Windows 7, Vista or Server 2008: If you will be installing SQL Server on Windows 7, Vista or Server 2008, we recommend that you read Microsoft's background material provided at


In particular, make sure you comply with the specified hardware and software requirements.

Default Backup Folder: SQL Server 2008 and R2 let you specify the default folder to be used to hold backup files. (SQL Server 2005 does not provide this ability.) We recommend that you set the default folder to be some device other that the disk drive that holds the actual MainBoss database. If your backups go to the same disk that holds your original database, a hardware error on that disk may kill both your database and the backups.

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