Install the new version of Treasury Software (client) on a workstation - preferably an IT workstation
Point the software to the server
Create databases - from the workstation
Follow the instructions for additional workstations - this will include login/security
Decide on a workstation to work from.
From this workstation you will be creating databases on the SQL Server. Therefore, if you are using Windows Authentication as your security model for the SQL Server, your Windows ID will need SQL Server administrator rights. You can use a user's machine to complete this check list only if they already have these rights.
If a user does not have these administrator rights, do not temporarily elevate a user's rights for this check list.
login on their machine as an administrator or
use a non-production workstation, such as an IT test machine or even a virtual PC which you can control the Windows login ID.
a. Download the new version of Treasury Software from the link below and save on a network drive.
b. Install the software on a workstation (make sure that you have administrator rights to the computer).
c. Start the software. From the 'Welcome New User' screen, select the application you are using (ACH, Bank Reconciliation or Positive Pay).
d. From the top menu select the 'Settings' tab then 'Migrate to SQL Express, SQL Server'.
Note: If you are using a version prior to 2013, from the main menu select 'File', 'Migrate to SQL' to start the SQL Server Migration Wizard.
Point to the new server (leave the check box blank).
If your server is not listed, you can type it directly into the pull down box. Click Next.
This is the USER's login information.
Select 'Integrated' (Windows Authentication), or
Enter the User's ID and password.
If you are unsure, check with your Database Administrator as to how your SQL Server is configured.
Click either 'Test Login ID', or click 'Next'.
Exit the software and re-start as prompted.
Upon re-entry, select an application from the Welcome New Users screen. The system will prompt you to create databases:
Leave the selection on 'Create', click 'Next'.
Note: In order to create new accounts you will need to have SA rights.
Provide authentication to the SQL Server:
Integrated/Windows Authentication - leave blank
SQL Server Authentication - enter your ID and password
Note: Do NOT elevate the user's credentials for this step, with the intention of returning it back later. If you do, you will have database ownership issues when returning the user's permissions back to their original level.
Enter an account name for the new SQL database and click 'Next'.
The system will create the database.
Note: If you are following these instructions as part of an upgrade or migration and do not need another account/database, simply create a database and then delete it later.
Afterwards, the system will prompt you that it is creating the Sample database. Click 'Ok'.
Never delete the 'Sample' database.
If you need to create more databases, simply select from the main menu File > New.
Grant your users permissions to the SQL Server and install on their machines by completing the following steps at 'Adding Additional Workstations'.
License codes - From the main menu select 'File' > 'Enter License Codes'. Enter the codes and click 'Register'.
Custom codes (if applicable) - From the 'Settings' tab select 'Import, System' then the custom tab.
Note: If you are using a version prior to 2013, from the main menu select 'File', 'Options', 'General', 'Custom' tab.
The #1 issue in any installation is security.
Make sure that you have a system administrator login ID before starting
Create/arrange for logins for all users
Confirm that the BankRecPosPayUser group has been granted rights to each database
Don't rollout to the users until you have fully tested the new system.
Having issues connecting? Try the following links:
Need help with permissions? Click here.
Can't make connection? Click here.
2400 Old Brick Rd
Glen Allen, VA 23060
All submissions answered same day*