Step 1: Create a SQL database

Before you install CS Time you need to create a database on your SQL server.

Example:

Using Microsoft SQL Server Management Studio, create a new database called CSTime.

Set the collation of the database to Latin1_General_CI_AS.

Step 2: Configure the SQL Login(s)

CS Time SQL can connect to the database using SQL or Windows authentication. Please check that your login(s) meet the server and database roles below.

Example:

Create a new login TNA which uses SQL Server autentication.

Select the following Server roles: bulkadmin, dbcreator, public and securityadmin.

Map the user to the CSTime database and set the Database role membership to db_owner.

Step 3: Installing CS Time on your server

Download the CS Time SQL version and save it somewhere on your computer. The file name will be CSTimeMSSQLInstall.exe for the Microsoft SQL Server version. When the download is complete, open and run the file.

An install wizard will open to guide you through the installation:

Select your location on the next screen.

Select the Install Type.

Select the Simple Install Type. This installs the CS Time application, the default CS Time data and also creates a shortcut to the CS Time Server Module which is used to collect clockings and process hours in real time.

The Advanced Install Type is used for installing on workstations / client computers. Click on Next to select the installation path.

The CS Time application installation path should be set to C:\CS Time Programs\CS Time. You may also select a different path to install CS Time to.

Click on Next to select the location of the data. The CS Time data is to be installed inC:\CS Time Programs\CS Time\Data.

Click on Next to view a summary of the installation details.

Click on Next to start the installation:

When the installation is complete you will see a window in which you have to enter the SQL connection details. Click on Cancel. The Connecting window will close.

Click on Finish to complete the installation.

Step 4: Configuring the SQL connect details

Open the Configuration module using the newly created shortcut in your Windows Start menu. You will see the following window:

Enter the SQL login and password next to UserName and Password. If you are using Windows authentication leave these fields empty.

Remember Password will save the password and Auto Login will connect automatically the next time you open CS Time. Donot select Auto Login until you have successfully connected to CS Time.

Click on Next to enter the Server details.

Enter the Server IP address and the SQL Instance name if one exists e.g. SQLServer\SQL2008. Enter the database name you created in Step 1.

Click on Connect.

CS Time will now start to create the tables in the database:

Once this process is complete the Configuration module will open.

Close the Jumpstart window and click on the File drop-down menu. Select File Manager, Tag All and click on Info to create the remaining tables. Close the File Manager screen when you are done. Close CS Time.

Use Windows Explorer to go to C:\ProgramData\CS Time and edit the CSTime.ini with Notepad. Add the following code below the last line:

[Server] Defrag = 0

Save the file and close it.

You can now copy the CS Time Server module into your Startup menu, or to install it as a service:

Run it first from the shortcut and double-click on the icon to open the CS Time Server.

Select Options and click on Install as a Service.

Close the Server module.

Go to your Windows Services and start the CS Time server.

Step 5: Client installations

You now have CS Time installed on your server. Next you can install CS Time on any client computers.

Repeat Step 3, but select the Advanced option at the Install type. The Advanced option will not install the CS Time Server shortcut and it will ask you for your server installation path and datapath:

Local Program Directory: select or enter the path where you want to install the CS Time application on the client computer.

Server DATA Directory: select or enter the path where the CS Time data is located on the server. This should point to location you have entered in Step 3, point 5.

Complete the installation of CS Time It is not necessary to do Step 4 in this case.

CS Time should now be able to connect to your server.

Important

If you are running backups on your SQL databases, please check that Quiet Time is set in CS Time for the period that the backups are scheduled for as this might cause deadlocking errors.

Exclude the CS Time application from your firewall and anti-virus software.

The CS Time users must have full read and write access to the CS Time data folders on the server and on the client computers.

If the CS Time Server is running on the same server as the SQL Server, please check that 1.5GB of memory is available to the operating system and that at least 1 to 2GB of memory is allocated to each database. See this forum post for more information.