Bank Reconciliation requires a SQL Express or a SQL Server backend.
SQL Express
SQL Express may be installed on a workstation or on a server.
1. Download the SQL Express database engine
Download the installation file from the link below based on the computer that you will be installing (hosting) the database engine on to:
Click here - For Windows XP, Vista, Windows 7, Server 2008, Server 2008R2
Click here - For Windows 8, Windows 10, Server 2012 and any operating system later.
Copy the downloaded installation file onto the hosting computer and run the installation. Remember: You need to be at the hosting computer, or remoted into it. You cannot simply copy the installation file to another computer's drive and install it from yours.
2. Download and install the software (client) to a user's workstation
Download and install from here.
Note: You can skip this step if you already have the software installed.
Start Treasury Software (client) and from the Welcome New Users screen select the application you are using (ACH Universal, Bank Reconciliation or Positive Pay).
From the 'Settings' tab, select 'Migrate to SQL Express, SQL Server'.
If you are prompted to install SQL Client tools, please do so, and then restart the Wizard by selecting the 'Settings' tab then selecting 'Migrate to SQL Express, SQL Server'.
From the drop down list, select the computer hosting the SQL Express database.
At the end of the Wizard, the system will prompt you to exit and re-enter the software. Please do so.
SQL Server
1. Install the new version of Treasury Software (client) on a workstation.
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.
Instead, either:
-
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.
http://www.treasurysoftware.com/download/index.aspx
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).
2. 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 pull down box. Click Next.
This is the USER's login information.
Either:
-
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.
3. 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 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.
