Home > Installing Office Timesheets > Office Timesheets Server Installation

Office Timesheets Server Installation

There are two primary components to the Office Timesheets server installation—the application and the database. Both components are installed and configured in one simple installation process; and the application and the database can both be installed to the same computer.

 

Tip: We have found in testing, particularly with larger installations, that Office Timesheets’ performance is greatly enhanced when the application and database are installed on two separate computers.

  

The Office Timesheets server components are developed using the latest Microsoft development tools and thus require Microsoft Windows-based hardware in which to operate. However, the Office Timesheets client can run on either Microsoft Internet Explorer or Firefox browsers. Firefox web browser compatibility allows the Office Timesheets client to run on a variety of computer operating system platforms, including both Windows and Apple Macintosh.

 

Note: Before installing Office Timesheets ensure that your computers meet the minimum system requirements. Click here to check the system requirements for Office Timesheets.

  

 

To install the Office Timesheets Server application:

  1. On your web server, double-click on the OTSInstaller.exe file which you downloaded to your computer.

     

    Note: The installer must be run from the computer on which you are installing Office Timesheets – your web server, in this case.

    		  


    The Office Timesheets Setup Wizard will start and the Welcome screen will be displayed.

Install Wizard Welcome

  1. Close all other Windows programs that are running and click Next.

The License Agreement will be displayed.

Install Wizard License Agreement

  1. Review the license agreement, and click the I agree to the terms of this license agreement radio button, and click Next.

Install Wizard Select Packages

  1. Specify whether to install only the original program (including the blank or live database) or the sample database as well.
 

Note: The original checkbox is checked by default. You cannot uncheck it.

  

 

 

Tip: We recommend that you check the Sample option as well so that you have a sample database to explore before configuring your blank Office Timesheets database.

  

Check or uncheck the Sample option (depending on whether you would like to install it or not) and click Next.

Install Wizard Select Folder

  1. Choose the location in which to install Office Timesheets and click Next.

You can accept the suggested location (“C:\Program Files\OTS”) or you can install Office Timesheets to some other location by clicking the Change… button. The space required and the space available on the selected drive are displayed for your reference.

Install Wizard Ready to Install

  1. The Installation Wizard now has enough information to install Office Timesheets on your computer. Review the installation information. If you need to make any changes, click the Back button to go to the previous screens and make the required changes. Otherwise, click Next to continue with the installation.

Install Wizard Virtual Folders

  1. Type in the names of the virtual directories for your live and sample databases (or keep the default names provided for you), and click Next.

Install Wizard Select SQL Windows Authentication

  1. Select the type of authentication you would like to use—Windows Authentication or SQL Server Authentication.
 

Note: If your SQL Server is not installed on the same computer as your Web Server, you must choose SQL Server Authentication.

  

If choosing Windows Authentication…

  1. Click on the Windows Authentication radio button, and click Next.

Install Wizard Configure Databases

  1. Type the name of the database server and the names of the blank and sample databases, and click Next.
Item How to use the Item Default Value
(if any)
Database Server Name Type the name of your database server. localhost
Database Name Type the name of the blank (or live) database. OTSDB
Sample Database Name Type the name of the sample database. OTSDBSample

Install Wizard Ready to Configure System

  1. Review the installation information. If you need to make any changes, click the Back button to go to the previous screens and make the required changes. Otherwise, click Next to continue with the installation.

If choosing SQL Server Authentication…

Install Wizard SQL Authentication
  1. Select the SQL Server Authentication radio button, and click Next.

Install Wizard Configure SQL Databases

  1. Type the name of the database server, the names of the blank and sample databases, as well as your login name and password and click Next.
Item How to use the Item Default Value
(if any)
Database Server Name Type the name of your database server. localhost
Database Name Type the name of the blank (or live) database. OTSDB
Sample Database Name Type the name of the sample database. OTSDBSample
Login Type the login name needed to access the databases.
Password Type the password needed to access the databases.

 

 

Install Wizard IIS Setup

  1. The installer will then create the virtual directory/directories in IIS and install the databases that you have selected.

Install Wizard Installation Successful

  1. Click Finish to complete the installation.

 

See also
Installing Office Timesheets with Microsoft SQL Server Express