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
Install the new version of Treasury Software (client) on a workstation
Decide on the initial workstation to use for the setup.
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 checklist only if they already have these rights.
If a User does not have 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 allows you to 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 Users' screen, select the application you are using (ACH Universal, Bank Positive Pay, or Bank Rec).
Point the software to the server
d. From the top menu, select the 'Settings' tab then 'Migrate to SQL Express, SQL Server'.
Point to the new server (leave the check box blank).
If your server is not listed, you can type it directly into the dropdown box. Click Next.
This is the USER's login information --
Select 'Integrated Authentication' (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.
Create databases - from the workstation
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 changing it back later. If you do, there may be 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'.
Note: Never delete the 'Sample' database.
If you need to create more databases, simply select from the main menu File > New.
SQL Server Security
Grant your Users permissions to the SQL Server and install on their machines by completing the following steps: 'Adding Additional Workstations'.
Enter License codes: From the main menu select 'File' > 'Enter License Codes'. Enter the codes and 'Click to Register'.
Custom codes (if applicable) - From the 'Settings' tab select 'Import, System' then the custom tab.
The number one issue in any installation is security.
Make sure that you have a system administrator (sa) login ID before starting
Create/arrange for logins for all users
Confirm that each User or Group who should have access to a database has the 'BankRecPosPayUser' role checked on the database(s), including the Sample database.
Don't roll out 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.