TimeTiger/Web Installation and Configuration

Last updated on August 31, 2004

Installing TimeTiger/Web on your Microsoft Windows server is a detailed process that you should complete with care. Please read through these instructions carefully prior to attempting the installation, and be sure to follow each step as described in this document. You may wish to print these instructions for convenience. Note that these instructions refer to TimeTiger version 1.8 and later.

This document assumes you are comfortable with Windows server administration and Internet Information Server. If you are using TimeTiger with Microsoft SQL Server, a solid understanding of Microsoft SQL Server administration and security issues is also highly recommended.

The configuration changes you make in the process of installing TimeTiger/Web may have security implications for your network. Be sure you understand the steps you are taking and what effect they have on your own organization's security policy.

If you require help at any time, send e-mail to support@indigo1.com with a detailed description of your problem, system configuration, and the steps you were able to complete successfully.

Definitions

TimeTiger/Web refers to what you have just downloaded and are about to install. The TimeTiger/Web logging interface is an Internet Information Server application that connects to your existing TimeTiger database and allows remote users to log, view and edit their time. TimeTiger/Web cannot function "stand-alone." You must also download and install the TimeTiger application in order to use it.

The TimeTiger application is the Windows program that provides advanced administrative and reporting functionality for the TimeTiger system. This program must be downloaded separately, and should be installed on at least one computer on your network so that you can administer and control the TimeTiger system. You can install it on other computers on your network to provide your users with features that are only available through the TimeTiger application.

The TimeTiger database is the Access 2000 .mdb file or Microsoft SQL Server database that you have created using the TimeTiger application. This database is accessible on your network so that other machines running the TimeTiger application can connect to it and perform TimeTiger operations.

System Requirements

For Windows 2003 (or later) Server installation:

Windows 2003 Server
Internet Information Server (comes with Windows Server)
128+ MB memory.
30+ MB hard-disk space.

For Windows 2000 Server installation:

Windows 2000 Server or Advanced Server
Windows 2000 Service Pack 1 or greater
Internet Information Server (comes with Windows Server)
64+ MB memory.
30+ MB hard-disk space.

For Windows NT Server installation:

Windows NT Server
Windows NT Service Pack 6 or 6a
Internet Information Server 4.0 (comes with Windows NT 4.0 Option Pack)
64+ MB memory.
30+ MB hard-disk space.

The clients that will be connecting to the TimeTiger/Web server must have:

JavaScript-enabled web browser software such as Internet Explorer 3+ or Netscape Communicator 4+

Installation Instructions

The installation procedure is divided into three sections. The first section, TimeTiger/Web Component Installation, describes how to install TimeTiger/Web onto your web server. The second section, Database Preparation, describes how to make your TimeTiger database available for TimeTiger/Web users. The final section, Web Server Configuration, configures your web server and enables TimeTiger/Web.

1. TimeTiger/Web Component Installation

Log into your web server as an Administrator.
Run the file ttwebset.exe, which you downloaded from the TimeTiger web site.
Follow the installation process through to completion. Remember the folder in which you installed TimeTiger/Web (the default folder is c:\Program Files\TimeTiger Web).

2. Database Preparation

On your network Domain Controller server, create a user account representing the web users that will need access to TimeTiger/Web. In Windows NT, go to Start, Programs, Administrative Tools, User Manager for Domains. In Windows 2000 or 2003, go to Start, Programs, Administrative Tools, Active Directory Users and Computers.
Add a user. The User Name should be TimeTigerWeb, or another name if you prefer.
Enter a password for this user. Be sure to make a note of the password you used. Do not use a blank password.
Make sure that "User must change password at next logon" is unchecked, and that "Password never expires" is checked.
If this user is not already in the Domain Users group, add it. Also add this user to the Guests group.
On your network web server (the Windows server that will be running TimeTiger/Web), log in as a system Administrator. Note that this machine should already have Internet Information Server installed and running.
If TimeTiger is using a Microsoft Access 2000 database:

In TimeTiger Explorer, Tools, Options, Advanced, click the Activate TimeTiger/Web button. This button will only be visible on TimeTiger 1.8 or higher, and if you use a Microsoft Access database.
Type the same password you used above and click OK. Note that you cannot use a blank password. Exit TimeTiger.
Move the database from its present network location to a location that physically resides on the web server. TimeTiger/Web can only use an Access 2000 database that physically resides on the same machine as Internet Information Server. If you move the database, you will need to visit each workstation running the TimeTiger application, start TimeTiger, Locate TimeTiger Database, and indicate the new network location for the database.
Use Windows Explorer to set permissions on the folder into which you placed the TimeTiger database file. Make sure that the TimeTigerWeb user you created has Full Control over the contents of this folder.

Note: As a security precaution, it is a good idea to keep the TimeTiger database in its own folder on your server.

Create an ODBC DSN for the TimeTiger database. In Windows NT, go to Start, Settings, Control Panel, ODBC Data Sources. In Windows 2000 or 2003, go to Start, Settings, Control Panel, Administrative Tools, Data Sources (ODBC). Click the System DSN tab. Click Add. Choose "Microsoft Access Driver (*.mdb)" and click Finish. For Data Source Name, type TimeTiger -- Note that exact spelling and capitalization is important here, and there is no space between the words Time and Tiger. Feel free to enter a description that suits you, although none is necessary. Click Select and find the TimeTiger database file on the server. In the System Database section, select the Database option and click the System Database... button. Navigate to the folder where your TimeTiger database resides and select the file of the same name but with the extension MDW (as opposed to MDB). Click OK. Click the Advanced button. For Login name, type (exactly) TTWeb and for the password type the password you used to Activate TimeTiger/Web (in Tools, Options, Advanced). Click OK 3 times to save your changes.

If TimeTiger is using a Microsoft SQL Server database:

Create an ODBC DSN for the TimeTiger database. In Windows NT, go to Start, Settings, Control Panel, ODBC Data Sources. In Windows 2000 or 2003, go to Start, Settings, Control Panel, Administrative Tools, Data Sources (ODBC). Click the System DSN tab. Click Add. Choose "SQL Server" and click Finish. For Data Source Name, type TimeTiger -- Note that exact spelling and capitalization is important here, and there is no space between the words Time and Tiger. Feel free to enter a description that suits you, although none is necessary. Select or type the name of the SQL Server that houses the TimeTiger database and click Next. Make sure that "With Windows NT authentication using the network login ID" is selected.

Note: TimeTiger/Web must use Windows Integrated Security, regardless of whether you have the TimeTiger application set up to use SQL Server standard security or Windows Integrated Security.

Click Next. Check "Change the default database to" and select the TimeTiger database on your SQL Server.
Click Next, then click Finish.
Click Test Data Source. You should see the message "Tests Completed Successfully!"
Click OK, OK again and OK a third time to save your DSN.
Using Enterprise Manager (the administrative application installed with your SQL Server), connect to the SQL Server housing your TimeTiger database. Open the Security folder (under Databases) and right-click Logins. Select "New Login..."
The name of the new login is YOURDOMAIN\TimeTigerWeb. Select Windows Authentication, Grant access. Set the Default database to the TimeTiger database. Click the Database Access tab. Check the Permit box beside the name of the TimeTiger database. Leave the Database Role 'public' checked, and check the TimeTigerUser role. If you do not have a TimeTigerUser role listed, see the section below entitled "Creating the TimeTigerUser role."

Creating the TimeTigerUser role (SQL Server only)

In order to allow your users access to the TimeTiger database, we recommend that you create a SQL Server role and add all your TimeTiger users, including the TimeTigerWeb user, to this role.

To create the TimeTigerUser role, open your TimeTiger database in SQL Enterprise Manager. Right-click Roles and choose New Database Role. Enter TimeTigerUser as the name. Click OK.

From the Tools menu, choose SQL Query Analyzer. In the SQL Query Analyzer, make sure the active database is the TimeTiger database and copy the following text into the query window:

		GRANT ALL ON [Analysis] TO TimeTigerUser 
		GRANT ALL ON [AnalysisEntity] TO TimeTigerUser 
		GRANT ALL ON [AnalysisField] TO TimeTigerUser 
		GRANT ALL ON [AutoMailDocument] TO TimeTigerUser 
		GRANT ALL ON [AutoMailRecipient] TO TimeTigerUser 
		GRANT ALL ON [Category] TO TimeTigerUser 
		GRANT ALL ON [Client] TO TimeTigerUser 
		GRANT ALL ON [Codes] TO TimeTigerUser 
		GRANT ALL ON [Hierarchy] TO TimeTigerUser 
		GRANT ALL ON [Invoice] TO TimeTigerUser 
		GRANT ALL ON [Project] TO TimeTigerUser 
		GRANT ALL ON [QuickPick] TO TimeTigerUser 
		GRANT ALL ON [Settings] TO TimeTigerUser 
		GRANT ALL ON [Task] TO TimeTigerUser 
		GRANT ALL ON [TempTimelog] TO TimeTigerUser 
		GRANT ALL ON [Timelog] TO TimeTigerUser 
		GRANT ALL ON [User] TO TimeTigerUser 
		GRANT ALL ON [UserGroup] TO TimeTigerUser
		GO

Execute the query to grant the required permissions to the TimeTigerUser role. Now, simply make sure that all users that need access to TimeTiger belong to this role.

3. Web Server Configuration

Log into your web server as an Administrator.
Start Internet Service Manager. In Windows NT, this is usually under Start, Programs, Windows NT 4.0 Option Pack, Microsoft Internet Information Server, Internet Services Manager. In Windows 2000 or 2003, go to Start, Settings, Control Panel, Adminstrative Tools, Internet Services Manager.

Windows 2003

In Windows 2003 only, you must enable Active Server Pages. Click on the Web Server Extensions folder which appears at the bottom of the tree under your server name. On the right-hand side of the screen, select Active Server Pages, and click Permit.

Navigate to the Default Web Site in the Web Sites folder.
Right-click on Default Web Site, click New, select Virtual Directory.
The Virtual Directory Wizard will start. Click Next. For the Alias, use TTWeb. Click Next.
When asked for the directory that contains the content, type in or browse to the path you installed the TimeTiger/Web components to (usually c:\Program Files\TimeTiger Web). Click Next.
You must allow the following permissions: Read, Run Scripts. Click Next.
Click Finish.
You will see that your virtual directory, TTWeb, has been created under your Default Web Site. Right-click on TTWeb and choose Properties. Click the Directory Security tab.
Under anonymous access and authentication control, click Edit.
Be sure "Anonymous access" is checked. Beside "Account used for anonymous access", click Edit.
For user name, enter YOURDOMAIN\TimeTigerWeb. Enter the password you used when creating the user. Do not allow IIS to control/synchronize the password. Click OK.
Uncheck all the other authentication options under "Authenticated access." Click OK.
Click the Documents tab. Make sure that Enable Default Document is checked and that Default.asp is in the list. If it is not, add Default.asp.
Click OK and OK again to save your changes.
Exit the Microsoft Management Console.

Logging in for the first time

From a browser on your web server or another machine connected to your network, enter the URL http://yourwebserver/TTWeb. You should see a TimeTiger login screen.
Enter the name and password of a valid TimeTiger user (not a network domain user) and click Login. You should see a Log Time form appear.
Enter a dummy time log entry (you must completely fill in at least the top row of the Log Time form). Click Submit. You should see a View/Edit Logs screen that shows your log at the top.

You're done!

Please write us at support@indigo1.com if you have any questions.

Common problems and error messages

You receive a web server error (usually error 500, Internal Server Error) when you enter the URL http://yourwebserver/ttweb.

Verify that your web server, and the Default Web Site, is running.
Verify that you have correctly created the virtual directory TTWeb and it points to the folder into which you installed the TimeTiger/Web components.
Reboot your web server and try connecting again.
If you get the same error, uninstall the application "TimeTiger Web" (from Start, Settings, Control Panel, Add/Remove Programs) and install it again from the original download file.

When you enter the URL http://yourwebserver/ttweb, a popup dialog box asks you to authenticate for the web resource, or you are told that authentication failed.

Check that the user TimeTigerWeb has been added to your domain, and not just local to your web server machine.
Check that the user TimeTigerWeb is a member of both the Domain Users and Guests group.
Check that the "Anonymous login" is enabled for your virtual directory TTWeb, that the user account used for anonymous login is YOURDOMAIN\TimeTigerWeb, and that the password is correct.
Check that the user TimeTigerWeb has at least Read and Script permissions on the folder TTWeb.

When you attempt to log in to TimeTiger/Web using an Access 2000 format database you receive error 80004005: Unspecified Error

Check that the DSN entry you made for TimeTiger points to the correct Access 2000 database file.
Check that the Access 2000 database physically resides on the same machine as your web server.
Check that the user TimeTigerWeb has Full Control permissions on both the database (.mdb) file and the folder in which it resides.
Check that the database is not corrupt by logging into it using the Windows TimeTiger desktop application.
Stop and restart the "World Wide Web Publishing Service" on your web server.

When you attempt to log in to TimeTiger/Web, you receive the message: Login failed for user /

Check that the user TimeTigerWeb has been added to your domain, and not just local to your web server machine.
Check that the user TimeTigerWeb is a member of both the Domain Users and Guests group.
Check that the "Anonymous login" is enabled for your virtual directory TTWeb, that the user account used for anonymous login is YOURDOMAIN\TimeTigerWeb, and that the password is correct.
If you are using a SQL Server database, check that a login has been added for user YOURDOMAIN\TimeTigerWeb in your SQL Server database, and that this login is Permitted to your TimeTiger database.

When you attempt to log in to TimeTiger/Web connected to a Microsoft SQL Server database, you receive the message: no SELECT permissions on table Settings.

Open your TimeTiger database in SQL Server Enterprise Manager. Check that, for every User table in the database, the user TimeTigerWeb has all possible permissions (SELECT, UPDATE, INSERT, and DELETE).

When you attempt to log in to TimeTiger/Web using a Microsoft Access database or you attempt to log time entries in TimeTiger/Web database, you receive the message "Could not use '(unknown)'; file already in use."

Check that the DSN entry you made for the database is not marked "Exclusive." You can check this by opening the DSN entry and clicking Options.
Check that no network users have opened the database file from the Microsoft Access application, which sometimes locks the database exclusively.

When you attempt to log in to TimeTiger/Web, you receive the message "Data source name not found and no default driver specified."

Check that you have created the DSN correctly.
Check that you have created it as a System DSN, and not a User DSN.
Check that you have named it exactly TimeTiger, with no punctuation and no spaces.

If you are still having trouble...

We are here to help. Please write support@indigo1.com with a detailed description of your problem, system configuration, and the diagnostic steps you were able to complete successfully.