How to install Sage Timeslips in a database server and application server environment (Windows Server 2012/2016/2019)
Description

Important: We recommend that your network administrator use these instructions as an example of how to set up Sage Timeslips multi-user on a client-server network. Following the recommendations in this document may affect the functionality of Sage Timeslips and your network. The network administrator (or user making these changes) is responsible for any issues that may arise from following these steps. You must be physically at the server to perform this install; you can not install TO the server from another workstation on the network.

These instructions provide an example of installing Sage Timeslips to a new or newly implemented Windows Server. These basic steps can be used on similar operating systems.

Cause
Since Windows Server is primarily intended as a dedicated server platform, we do not recommend running Sage Timeslips on a dedicated server. However, we understand that in some circumstances this may be the preferred method of installation. Please note that using Sage Timeslips on the server will also claim and hold a Sage Timeslips license.
Resolution
[BCB:3:Network warning:ECB]

Summary of Steps

  • Install Sage Timeslips database components to the database server
  • Create a network share for Sage Timeslips Premium on your application server
  • Install Sage Timeslips Premium to the network share on your application server
  • Perform local installations to your Sage Timeslips workstations from the network share on the application server
  • Launch Sage Timeslips on local workstation to start the setup and configuration between the database server and application server

Install Sage Timeslips Database Components to the Database Server

Server Considerations:

  • We do not recommend installing Sage Timeslips under the C:\Program Files\Timeslips on a server due to Windows limitations when accessing shared data under Program Files.
  • You must be physically at the server to perform this install. You cannot install to the server from another network machine.
  • Make sure that your database server is on the same network and visible to the application server.


  • Sage Timeslips communicates via port 3050, make sure that port 3050 is open in your network firewall on the Database Server only. You can review instructions on how to open a port by reading KB article 63862 'How to open port 3050 in Windows Firewall for Sage Timeslips Premium' in Related Resources below.
  • If you are on a monthly subscription and installing the Premium version, you must make sure you have an active internet connection to validate your account.


Finding the serial number, configuration code/activation key and account ID

You will need your serial number, configuration code/activation key and account ID to install Sage Timeslips, register Sage Timeslips, and to receive technical support (if necessary). Sage sent this information to you in an email message shortly after your order.

Understanding single-user configurations

When using Sage Timeslips Premium, a single-user installation refers to any installation that has one station license. Some single-user installations include:

  • Single-user installation with one computer – If you purchased a single license of Sage Timeslips and you own a single computer, the program files and database will reside on this computer.
  • Single-user installation on a network workstation with the database on a network workstation – If you purchased a single station license of Sage Timeslips and your workstation is connected to a network, you can install Sage Timeslips on your local workstation and maintain your Sage Timeslips database on that same workstation.
  • Single-user installation on a network workstation with the database on a network drive – If you purchased a single station license of Sage Timeslips and your workstation is connected to a network, you will not be able to maintain a database across the network. Your Sage Timeslips Database must reside on your local hard drives on your workstation.
    Understanding network configurations.

Understanding network configurations

If you purchased multiple Sage Timeslips station licenses, then multiple users (up to the number of station licenses purchased) can access the database simultaneously. To support multiple-user access, you must install Sage Timeslips Premium in a network environment. This section describes common network configurations:

  • Peer-to-peer networks – If your firm has workstations networked in a peer-to-peer environment (where workstations can access drives on other workstations), the first workstation on which you install Timeslips is considered the Timeslips server.
  • Network installation – If your firm has network workstations and a network server (which contains shared network drives), you can install your initial Timeslips installation on the network server. In this configuration, your firm’s network server is the Timeslips Server.

In network installations, after installing Sage Timeslips on the first computer, you can use the local installer to install Sage Timeslips to each network workstation that will access Timeslips. For additional information about configuring your network workstations, see KB article 63864 - 'How to Perform a Local Installation of Sage Timeslips Premium' in Related Resources below.

You can install Sage Timeslips in many network environments. Our online knowledgebase includes detailed installation instructions for some of these specific network environments. To access our online knowledgebase for installation guides, please please refer to KB article 63919 - 'Sage Timeslips Premium and 2017+ Network Installation Guides' in Related Resources below.

Perform the installation of the Timeslips database engine and database folder location on your dedicated database server.

  1. Download the Sage Timeslips installation file. If the installation process does not start automatically, start the installation by double-clicking on the Sage Timeslips download file. The download file will extract the necessary installation file and will open a menu of options.
  2. Choose Install Sage Timeslips
  3. During the wizard when asked if this is the Application Server or Database Server, choose Database Server installation.
  4. Choose your database path where your databases will be stored.
  5. Once installation completes, your database server will be installed and set up.
  6. On the Database Server; located in C:\Program Files (x86)\Timeslips Firebird Server\Timeslips, you will find an application called TSAdmin.exe. This utility is used to register databases on your Database Server without having to install the Sage Timeslips Premium application.
  7. You do not need to specifically share any folders on your Database Server.
  8. Write down the computer name of your Database Server as you will need this when you install and setup the Application Server.

Create a Network Share for Sage Timeslips on Your Application Server

  1. On the Sage Timeslips server, From the Windows Start menu, select Computer.
  2. Double-click the drive you want to create the shared volume on. The C: drive is commonly reserved for boot and system files. It is customary to store data files such as Sage Timeslips on a different volume. In our example, we will use the D: drive.
  3. Click File, New, Folder. Name the folder TSSHARE.
  4. Right-click the TSSHARE folder, and select Properties, click the Sharing tab, click the Share button. You can choose to share with specific users or you can choose to just share the Everyone group, depending on how secure you want your network share to be. We recommend speaking with a network administrator for advice on your network setup and implementation.
    • Set up the proper permissions for this shared volume. By default Windows Server assigns minimal rights to new shared volumes. You must have and grant at least Read/Write permissions to this folder.
    • For Permissions, click Read and Write for the desired users or you can choose Everyone and mark them as Read/Write for a simplistic setup. Network administrators may choose to be more selective with specific users and specific permissions.

Outlined below is information on the differences between Read and Write rights.

Read is the default permission that is assigned to the Everyone group. Read allows:

  • Viewing file names and subfolder names
  • Viewing data in files
  • Running program files

Write/Change is not a default permission for any group. The Change permission allows all Read permissions, plus:

  • Changing file names and subfolder names
  • Changing data in files
  1. Click OK on the Permissions window.
  2. Click OK on the TSSHARE Properties window. The share should now be visible to other computers on your network.
  3. If you have a firewall enabled, it is necessary to make sure that port 3050 is open. The Firebird Database engine that Sage Timeslips uses transmits data to and from network machines via this port. If it is closed Sage Timeslips will not be able to open databases on your server.

Note: To complete this setup, you must be certain of the server's machine name. To determine this name, right click Computer and choose Properties to find the computer name. Alternatively, open a Run box via the Windows Key+R on your keyboard, typing CMD, and typing HOSTNAME and press Enter. The result will be the machine name.

Install Sage Timeslips to the network folder share you created on your Application Server
Sage Timeslips should be installed in a shared folder under the Local Volume (C: drive, D: drive, etc.); for example, C:\TSSHARE\Timeslips or C:\APPS\Timeslips.

Server Considerations:

  • We do not recommend installing Sage Timeslips under the C:\Program Files\Timeslips on a server due to Windows limitations when accessing shared data under Program Files.
  • You must be physically at the server to perform this install. You cannot install to the server from another network machine.
  1. Launch the Sage Timeslips installation program
  2. Choose Install Sage Timeslips
  3. During the wizard when asked if this is the Application Server or Database Server, choose Application Server.
  4. Choose your network share that you set up previously in above in the Create Timeslips Share steps.
  5. Once installation completes then your Application Server is installed.

If you are using Sage Timeslips on the server, install on the server first before running any local installations on workstation installations.

On any computer that uses Sage Timeslips, browse to this network folder. If you use the server as a workstation, you do not need to follow the instructions for local installation outlined below on the Sage Timeslips Server, you may run and use Sage Timeslips as installed on the server.

Perform Local Installs to your Sage Timeslips Workstations

On your workstation, perform your local install. This is not necessary on the server itself.

  1. Click Start, Run - or Windows Key+R - and type \\server_name and press Enter, where the server name is the name of your server. The network share TSSHARE should be listed as a folder. If you do not get this result, make sure that you have shared TSSHARE properly and that you have the correct name of your Timeslips server and the share you created.
  2. Double-click TSSHARE.
  3. Open the Timeslips folder, then the LoclInst folder, and double-click on Setup.exe to start the installation.
  4. Upon starting the local installation, choose the desired installation type.
  5. Choose the location for Sage Timeslips. On 32-bit workstations, this is typically C:\Program Files\Timeslips\ and on 64-bit workstations, typically C:\Program Files (x86)\Timeslips\.
  6. After the installation is complete, start Sage Timeslips. Select Help, About Sage Timeslips. The Installation folder should be \\server_name\Timeslips and the Application folder should be identical to the path specified in step 5 above.
  7. Perform this local install on each of your workstations.

Launch Sage Timeslips on Local Workstations to Start the Setup and Configuration between the Database Server and Application Server

Important Considerations:

You can perform this sitting at the server or going to a local machine after a local installation has been completed.

  1. Launch Sage Timeslips.
  2. You will be prompted with a dialog that will allow you to enter your Server name of your Database Server to complete the final connection.
  3. Use the Computer name of the Database Server you wrote down when you installed and setup the Database Server earlier.

DocLink: How to open port 3050 in Windows Firewall for Sage Timeslips
DocLink: How to perform a local installation of Sage Timeslips
DocLink: Sage Timeslips installation guides


[BCB:167:Chat Timeslips US:ECB] 


Steps to duplicate
Related Solutions