OfficeStatus Server is backed by a managed SQL Server database, the creation and configuration of which is handled automatically by the product installer. A full listed of supported databases (many of which are free) is provided here.
The OfficeStatus Server installer will prompt you to choose a specific SQL Server instance which will host the OfficeStatus database. You can either enter a known SQL Server address into the specified field, or click the drop-down arrow to build a list of available SQL Servers on the local network (including the local host computer) 1. If you elected to install a named instance of SQL Server Express during the OfficeStatus Server installation process, the server instance will automatically be preset to "(local)\OfficeStatus".
In order to create and configure the OfficeStatus database, the installer must log in to your SQL Server database as a System Administrator (e.g. member of the "sysadmin" role). Two different authentication methods are supported:
•Windows Integrated - The Windows account under which you're currently logged in must be a SQL Server database administrator.
•SQL Server - Uses a built-in SQL Server account which is configured as a database administrator.
The OfficeStatus Server installer will use this information in the final stages of installation to do the following:
•Create a database named "OfficeStatus"
•Create a SQL Server login bound to the Windows user account specified in an earlier installation step
•Assign OfficeStatus database ownership to the SQL Server login
This step of the installer will also allow you to choose to attach to an existing OfficeStatus database. This is an advanced option and is generally only used when you're performing a full re-install of the product and wish to attach to an existing OfficeStatus database.
Tip 1: When installing OfficeStatus Server on the same machine that hosts a default instance of SQL Server Express, the SQL Server instance address will be "(local)\SQLExpress". If you installed SQL Express during the OfficeStatus Server installation, the instance address will be "(local)\OfficeStatus".
Tip 2: If your current, logged-in user account is not a SQL Server system administrator, you can always use the "sa" account for this step (as long as your SQL Server instance has mixed mode authentication enabled).
1. The SQL Server discovery mechanism can only find a specific SQL Server instance if its SQL Browser service is enabled.