CS Time/TNA Documents

username password

Installing CS Time SQL

    The SQL version of CS 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.

    This document illustrates how to do a new CS 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 CS Time with Impro, please read the Impro & CS Time document first.

     

    CONTENT

    Step 1: Create a SQL database

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

    Example:

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


    Installing - 1.png

     

    1. Set the collation of the database to Latin1_General_CI_AS.


    Installing - 2.png
     

    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:

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


    Installing - 3.png
     

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


    Installing - 4.png
     

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


    Installing - 5.png

    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. 

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

      Installing - 6.png
       

    2. Select your location on the next screen.

      Installing - 7.png
       

    3. Select the Install Type.
       

      Installing - 8.png
       

      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.

       

       

    4. 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. 


    Installing - 9.png

     

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

       


      Installing - 10.png

       

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

      Installing - 11.png
       

    3. Click on Next to start the installation:
       

      Installing - 12.png
       

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

    5. Click on Finish to complete the installation.

       

      Installing - 13.png

       

    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:


    Installing - 14.png

     

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


    Installing - 15.png

     

    1. Click on Connect.
    2. CS 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 CS Time.

    2. 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.

    3. You can now copy the CS 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 CS 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 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.

    1. 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:
      1. Local Program Directory: select or enter the path where you want to install the CS Time application on the client computer.
      2. 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.
    2. Complete the installation of CS Time  It is not necessary to do Step 4 in this case.
    3. CS 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 CS Time for the period that the backups are scheduled for as this might cause deadlocking errors.
    2. Exclude the CS Time application from your firewall and anti-virus software.
    3. 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.
    4. 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.

     

    Permalink:  http://tinyurl.com/lt8aafv

    Page last modified 16:12, 4 Jun 2015 by cay-lynne CS Time/TNA Documents > Installing CS Time > Installing CS Time SQL

    Comments0

    You must login to post a comment.
    Attach file

    Files15

    FileSizeDateAttached by 
     Installing - 1.png
    No description
    14.65 kB15:24, 22 Apr 2014cay-lynneActions
     Installing - 10.png
    No description
    10.52 kB16:48, 17 Mar 2014cay-lynneActions
     Installing - 11.png
    No description
    11.86 kB16:48, 17 Mar 2014cay-lynneActions
     Installing - 12.png
    No description
    10.22 kB15:35, 22 Apr 2014cay-lynneActions
     Installing - 13.png
    No description
    91.14 kB16:48, 17 Mar 2014cay-lynneActions
     Installing - 14.png
    No description
    14.14 kB15:42, 22 Apr 2014cay-lynneActions
     Installing - 15.png
    No description
    18.32 kB15:42, 22 Apr 2014cay-lynneActions
     Installing - 2.png
    No description
    11.6 kB16:11, 4 Jun 2015cay-lynneActions
     Installing - 3.png
    No description
    12.15 kB15:24, 22 Apr 2014cay-lynneActions
     Installing - 4.png
    No description
    13.02 kB15:25, 22 Apr 2014cay-lynneActions
     Installing - 5.png
    No description
    26.72 kB15:25, 22 Apr 2014cay-lynneActions
     Installing - 6.png
    No description
    95.94 kB16:47, 17 Mar 2014cay-lynneActions
     Installing - 7.png
    No description
    10.69 kB16:47, 17 Mar 2014cay-lynneActions
     Installing - 8.png
    No description
    10.83 kB16:47, 17 Mar 2014cay-lynneActions
     Installing - 9.png
    No description
    10.13 kB16:48, 17 Mar 2014cay-lynneActions
    Powered by MindTouch Core