SQL Server Installation

< 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 use (e.g. to back up the database). However, SQL Express is available at no charge and can be used successfully with MainBoss, especially by small maintenance departments.

If you will be installing SQL Server, we recommend that you read Microsoft's background material provided at

https://docs.microsoft.com/en-us/sql/database-engine/install-windows/install-sql-server

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. We recommend that you set the default folder to be some device other than 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 >