Like many modern business software applications, OfficeStatus relies on a back-end relational database for its data storage requirements. You can either establish a database server instance prior to installing OfficeStatus Server, or elect to download and install a named instance of SQL Server Express 2008 R2 during product installation.
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 2016 (Standard, Web, Business Intelligence, or Enterprise editions)
•SQL Server 2014 (Standard, Web, Business Intelligence, or Enterprise editions)
•SQL Server 2012 (Standard, Web, Business Intelligence, or Enterprise editions)
•SQL Server 2008 (Standard, Workgroup, Web, or Enterprise editions)
•SQL Server 2005 (Standard, Workgroup, or Enterprise editions)
Supported free SQL Server database platforms:
•SQL Server 2016 Express Edition - FREE
•SQL Server 2014 Express Edition - FREE
•SQL Server 2012 Express Edition - FREE
•SQL Server 2008 Express Edition - FREE
•SQL Server 2005 Express Edition - 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 Express Edition. SQL Server Express is a light-weight, easy-to-use versions of the commercial SQL Server engines. It is generally appropriate for OfficeStatus installations with 25 to 100 users, depending upon usage and configuration.
IMPORTANT: The OfficeStatus Server installer includes an option to install a local, named instance of SQL Server Express 2008 R2. When this option is chosen, the installer will automatically target this database instance in subsequent installation steps.
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 scenarios 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).