thewealthworks Customer Support Portal

Installation Guide

These notes are to guide an IT professional through the installation of Troika.

For our existing clients, the following notes will guide through how to install Troika onto a new single workstation, on a network where Troika is already installed. Please follow the steps under the section 'Installing the Workstation Troika Programs'.

For new clients, the notes will guide through the entire process of installing Troika into your environment.

In the event of planned deployment in a Citrix or Terminal Services environment, please arrange for a technical conversation with your sales contact.

In the event of any other installation queries, please contact support.

Introduction

Troika is a client server application which uses a web interface (Microsoft Internet Information Services), workstation components (Microsoft Office, Microsoft Access Runtime and Visual Basic) and a Microsoft SQL Server database. These instructions include full details and additional information for installing:

• The centrally located Troika files and folders, on a file server,
• The SQL database, and
• The workstation components and programs necessary to run Troika.  

A single full version of Microsoft Access for one user is also required for system support purposes, along with Microsoft Office. Please see the latest system specifications for the full software requirements available here:

System Requirements - WealthWorks+ and Troika

All workstations will require a Microsoft Access Runtime installation, in the event a full version of Microsoft Access isn't already present.

Separate instructions are also provided specific to each release of Troika and these are displayed as a PDF file when applying the updated programs to your system.   

WealthWorks+ programs also include their own full installation and update instructions which need to be followed.

Downloading and copying the installation files and folders

If you have been provided with an installation file, a number of sub-folders will exist within it and their contents are outlined below. If you have downloaded the installation file, the same folders will be provided as compressed ‘.zip’ files that must be extracted to create the same folders.

Setting up the centrally located Troika files and folders

1. Troika requires access to a series of shared folders on a file server. Once this location has been determined, create a shared folder called ‘TWWDATA’ and map a drive letter to \\SERVERNAME\TWWDATA\. Please note, a mapped drive T: will be referred to in these notes. Assign full read/write permissions to this shared folder, to an account that each Troika user will have. If a different drive letter or path is assigned, the 'TroikaSQL.ini' configuration file, installed on each workstation as part of this install process, will need to be amended to reflect the correct drive of these shared folders.

2. Create the following directories as shown below. Ensure Troika users have full read, write and delete permissions to these folders and sub folders:

• T:\Resources
• T:\Resources\Documents
• T:\Resources\Install_Files
• T:\Master
• T:\Tax
• T:\Imports
• T:\Forms
• T:\Exports
• T:\Accounts
• T:\Release
• T:\Letter_Templates

A copy of the folder and sub folder structure is available on the initial installation file, in the location \Resources\TWWDATA_Folders_Required, should you wish to copy these directly.

3. Unzip and copy the following folder contents as indicated:

Restoring the SQL database backup

You will need your database administrator to restore the Troika data on your SQL Server. We will either provide you with a blank set of Troika data to your specification, or migrate data from your legacy system if we have undertaken this as part of your system agreement. Either way, the SQL database will now be located in your default SQL Server backup folder in a ‘.bak’ file format.

The SQL Server should be configured as required on your network. Ensure the regional settings are set to locale (English) United Kingdom. SQL Server requires a standard Windows Collation (Character Set & Sort Order), to load the initial data configuration on to your server. Please see the following article for further information about regional settings and windows collation settings:

System Requirements - WealthWorks+ and Troika

How to restore the SQL database backup file

This operation should be carried out by your database administrator. Please ensure you have up-to-date and verified backups before attempting to run any operations on your server. These notes are intended for guidance only and should not be relied upon. Always seek advice from your Database Administrator (DBA) before completing any work on SQL Server.

• Open SQL Server Management Studio from the start menu on your server. Enter your log-in credentials, if required.
• Expand the console tree on the left hand side of the console. Find the folder containing the ‘Databases’.
• Right click on the database folder to select ‘create a new database’, giving it a name of 'Troika'.
• Right click on the new database name, choose 'Tasks' and choose the option ‘Restore database’.
• Click on the ‘From Device’ button and choose the 'Select Devices' button.
• Click on ‘Add’ on the next screen. Locate the file in the default folder to be restored. Click OK.
• Click on the OK button to return to the Restore Database screen.
• Ensure the Database Name correctly shows 'Troika' at the top of the screen. If not, amend.
• Click on the Options tab and check the setting ‘force over existing database’ is checked.
• Also check the two ‘move to physical file name’ paths are assigned to the correct paths for your server. The paths should point to your SQL data ‘.mdf’ file and to the SQL log files ‘.ldf’ file.
• Once these are checked, click on OK to begin the restore process.
• This cannot be reversed. Ensure you have safe and adequate back-ups of your data before attempting any restore procedures.

Assigning user database access with SQL logins

Create the following SQL logins on your SQL Server and assign the database mappings to your Troika SQL database as follows:

If you are using SQL authentication, ensure the SQL Server authentication is set to ‘SQL Server and Windows Authentication’ (mixed mode). If either the db_TR_USER or db_TR_SQL_ADM SQL roles are missing from your SQL Troika database, please see the following article here. 

Check the new database is also included in any existing SQL Maintenance plan and a backup of the database is being performed with a suitable frequency.

Please see Appendix A for full details of SQL administration and file backup requirements for Troika.

Installing the ‘Master’ Troika Programs

These steps should be completed on the file server and webserver only, and do not require installation on each workstation (apart from running the Troika desktop update option after completing step 13).

Installing the Workstation Troika Programs

Before attempting any program installation, ensure you have sufficient rights on your operating system to install the applications successfully. You must be logged on as an Administrator to perform the installation and set-up process.

Ensure that the Administrator or user is a member of the administrator group before proceeding. You must be logged on to the operating system as this user to complete the installation.  You may also be required to re-boot the workstation after installing the programs. You may need to set the user access control to low, particularly on a 64-bit operating system.

Workstation Installation

Starting Troika from the Troika Desktop

All Troika desktop program modules and WealthWorks+ can be accessed by starting the Troika Desktop. This is usually started by double-clicking on the Troika Desktop icon. This will start the Troika Desktop application running in the Windows system tray, at the end of your task bar. Right click on the Troika Desktop icon in the system tray to view the Troika Desktop options, or double click to see the Troika Desktop screen. Additional options can be accessed by right clicking at the top of the Troika Desktop.

Logging In/Logging Out

To log in to the Troika Desktop application click ‘Log in’. The Troika log-on screen will then be displayed. After you have typed in your user initials, press the tab key to move down to the password field. The initials can be typed in either case but the password is case sensitive. If you type the user name or password incorrectly, you will see the message 'Incorrect password'. Click on the OK button to return to the logon screen to try again.

Once the user has been logged on to the Troika Desktop application successfully, no further logging on is required to access the individual system modules. If the user needs to log-in using different initials, then the log-out option on the Troika Desktop needs to be used to completely log-out of the system. The connection with the database is not dropped until the desktop application has been exited from.

System Modules

Clicking on the desktop buttons will start each of the system modules and will check the connections with your server.

• Wealth Management, opens in a Microsoft Access session
• Administration and Compliance, opens in a Microsoft Access session
• Time and Billing, opens in a Microsoft Access session
  • Timesheet – starts the time entry screen, without running the full Time and Billing module
  • Timer – starts the time clocks running
• Utilities, opens in a Microsoft Access session
• WealthWorks+, opens in the default workstation internet browser

Update Menu Option

The 'Update' option can be used to update the Troika main module files from the central location on the file server. This makes updating and rolling out program updates for Troika to local workstations and user profiles simpler. The Troika program files use Access database files and additional VB components. The main files used are listed for your information:

• Troika Wealth Management, fpsTroik.mdb
• Troika Investment Management, fpsTrim.mdb
• Troika Administrator, fpsTrSec.mdb
• Troika Time and Billing, fpsTime.mdb
• Troika Utilities, fpsUtil.mdb
• Troika Desktop, fpsStart.exe

The 'Update' program is ‘fpsUpdate.mdb’ and the entries in the default 'TroikaSQL.ini' file are used to locate both the local and master copies of the Troika programs.

Additional Troika Configuration Settings

Additional notes are available in Appendix C, if you require assistance with:

• Amending the database connection
• Amending the default configuration file 
• SQL script updates to the Troika SQL database
• The remote support viewer application

Troika Datafeed
 

Automated datafeeds are available and can include investment pricing, dividend, exchange rate and corporate action data. Please contact support for further information on our datafeed suppliers.

Adding New Accounts Formats to Troika

As part of your system agreement, you may have been provided with some of our accounts formats.

These formats can be added to your Troika system now, using the following instructions:

System Installation Guide - Adding New Accounts Formats to Troika

Additional Troika Accounts Configuration Settings

Additional notes are available in Appendix D, if you require assistance with:

• Troika Accounts – key system files
• Registry settings for Troika Accounts
• 'TroikaSQL.ini' file settings for Troika Accounts
• Presentation issues in Microsoft Word

Appendices

Appendix A:  SQL Administration Requirements

As a licensee you are responsible for managing the procedures that keep your data in the best possible condition.  Where appropriate you should pass the details within Appendix A, to your database administrator. 

Appendix B:  Creating a database connection (DSN)

Once the installation routine is completed, you will need to create a 32 bit ODBC data connection to the database.  Please refer to Appendix B, for assistance with this.

Appendix C:  Additional Troika configuration settings 

Please refer to Appendix C, for additional Troika configuration settings.

Appendix D:  Additional Troika Accounts configuration settings

Please refer to Appendix D, for additional Troika Accounts configuration settings, if needed for your installation.

Appendix E:  Installing Troika to Windows Terminal Services / Citrix XenApp

Please refer to Appendix E, for an overview of the issues for an installation of Troika on Terminal Services and Citrix XenApp.

These notes were last reviewed 03/2023.