Installing SQL Express |
< Previous section | Table of Contents | Index | Next section >
The following description assumes that you do not have any instance of SQL Server installed on your computer. To determine whether you do have such an installation, go to the Windows Control Panel and check "Programs and Features".
Microsoft recommends that SQL Express be installed with a limited permission set and/or as a limited user. For information on this process, see https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-windows-service-accounts-and-permissions
If you ever intend to have multiple MainBoss users, we offer the following suggestions as options to choose during installation. Your site might decide to make different choices, but our suggestions should help typical users find their way through the many possibilities.
Unless otherwise stated below, we recommend that you accept the default options in each phase of the installation.
The options above constitute a standard configuration for use with MainBoss. They match Microsoft's recommendations for SQL Server. If you make different configuration choices, you may find you have to make changes in future. Also, if you run into trouble, MainBoss Technical Support may recommend that you reset your SQL Server options as listed above.
SQL Express Installation Notes: After installing SQL Express, you must enable TCP/IP connections. This process is described later in this guide in the section SQL Server Configuration.
If you intend to connect with SQL Express from other computers, you must also adjust the Server computer's firewall to allow remote users to connect with the SQL Server and the SQL Server Browser. This process is explained in Adjusting the Firewall.
Finally, you may have to adjust your local security settings to allow access to shared files. This process is explained in Local Security Settings.
< Previous section | Table of Contents | Index | Next section >