Locate (Contains) :

Installing Eco Time SQL

The SQL version of Eco Time uses Microsoft SQL Server (2005 and later) as the database server. Please check that your server meets the[ hardware and software requirements for SQL Server|http://msdn.microsoft.com/en-us/library/ms143506.aspx#SEx64].
This document illustrates how to do a new Eco Time SQL installation. It assumes that a version of Microsoft SQL Server is already installed and ready for use.
If you are going to be using Eco Time with Impro, please read the Impro & Eco Time document first.


CONTENT

  1. Step 1: Create a SQL database
  2. Step 2: Configure the SQL Login(s)
  3. Step 3: Installing Eco Time on your server
  4. Step 4: Configuring the SQL connect details
  5. Step 5: Client installations
  6. Important
 

Step 1: Create a SQL database

Before you install Eco Time you need to create a database on your SQL server.
Example:

  1. Using Microsoft SQL Server Management Studio, create a new database called Eco Time.

 
  1. Set the collation of the database to Latin1_General_CI_AS.

 

Step 2: Configure the SQL Login(s)

Eco 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:

  1. Create a new login TNA which uses*SQL Server autentication*.

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

  1. Map the user to the Eco Time database and set the Database role membership to db_owner.

 

Step 3: Installing Eco Time on your server

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

  1. An install wizard will open to guide you through the installation:
     
  2. Select your location on the next screen.
     
  3. Select the Install Type.


    Select the Simple Install Type. This installs the Eco Time application, the default Eco Time data and also creates a shortcut to the Eco 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.
  4. The Eco Time application installation path should be set to C:\Eco Time Programs\EcoTime. You may also select a different path to install Eco Time to.

 
  1. Click on Next to select the location of the data. The Eco Time data is to be installed in C:\Eco Time Programs\EcoTime\Data.
     
  2. Click on Next to view a summary of the installation details.
     
  3. Click on*Next*to start the installation:
     
  4. 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.
     
  5. Click on Finish to complete the installation.
 

Step 4: Configuring the SQL connect details

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

 
  1. 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 Eco Time. Do not select Auto Login until you have successfully connected to Eco Time.

    1. Click on Next to enter the Server details.
    2. 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.

 
    1. Click on Connect.
    2. Eco Time will now start to create the tables in the database:


Once this process is complete the Configuration module will open.
    1. 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 Eco Time.
    2. Use Windows Explorer to go to C:\ProgramData\Eco 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.
    3. You can now copy the Eco Time Server module into your Startup menu, or to install it as a service:
      1. Run it first from the shortcut and double-click on the icon to open the Eco Time Server.
      2. Select Options and click on Install as a Service.
      3. Close the Server module.
      4. Go to your Windows Services and start the Eco Time server.
 

Step 5: Client installations

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

    1. Repeat Step 3, but select the *Advanced*option at the Install type. The Advanced option will not install the Eco Time Server shortcut and it will ask you for your server installation path and datapath:
      1. Local Program Directory: select or enter the path where you want to install the Eco Time application on the client computer.
      2. Server DATA Directory: select or enter the path where the Eco Time data is located on the server. This should point to location you have entered in Step 3, point 5.
    2. Complete the installation of Eco Time It is not necessary to do Step 4 in this case.
    3. Eco Time should now be able to connect to your server.
 

Important

    1. If you are running backups on your SQL databases, please check that Quiet Time is set in Eco Time for the period that the backups are scheduled for as this might cause deadlocking errors.
    2. Exclude the Eco Time application from your firewall and anti-virus software.
    3. The Eco Time users must have full read and write access to the Eco Time data folders on the server and on the client computers.
    4. If the Eco 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.

 

Updated by Robert de Jager on 11 MAY 2022
Locate (Contains) :