Like many modern business software applications, OfficeStatus relies on a back-end relational database for its data storage requirements. A database server, installed either locally or on a remote server, must be available prior to the installation of OfficeStatus Server.
OfficeStatus was designed to support a range of Microsoft database platforms, some of which are entirely free.
Supported commercial SQL Server platforms include:
| • | SQL Server 2008 (Standard, Workgroup, Web, or Enterprise Editions) |
| • | SQL Server 2005 (Standard, Workgroup, or Enterprise Editions) |
| • | SQL Server 2000 SP4 (Standard, Enterprise Editions) |
Supported free SQL Server database platforms:
| • | SQL Server 2008 Express Edition - FREE |
| • | SQL Server 2005 Express Edition - FREE |
| • | MSDE 2000 SP4 - FREE |
If you already have a licensed copy of SQL Server running on your local area network, then you don't need to take any additional steps. OfficeStatus Server will automatically recognize existing SQL Server instances during installation, and you'll have the option to select one.
If you don't already have a licensed version of SQL Server running, we recommend using SQL Server 2005 Express Edition or SQL Server 2008 Express Edition. SQL Server Express 2005 and 2008 are free, light-weight, easy-to-use versions of the commercial SQL Server engines. They are generally appropriate for OfficeStatus installations with 25 to 100 users, depending upon usage and configuration. Note that existing MSDE 2000 databases can also be upgraded to SQL Server 2005 Express.
Whether you install the database server software on the same computer as OfficeStatus Server or on a different computer (on the same network) is entirely up to you. OfficeStatus will handle both arrangements equally well, with a very small performance gain (unnoticeable in the majority of cases) being derived from having the database available locally (e.g. on the same computer).
The OfficeStatus Server installation package will handle the creation of an OfficeStatus database (including required login, schema, and default data). You need only make one of these database platforms available prior to the start of installation - OfficeStatus will handle the rest.