Download Free Trial 2 Min Demo Contact Us
(866) 226-5732
Easily Create & Transmit ACH Files

 

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.

Select 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.

Select server

This is the USER's login information.

Either:

  1. Select 'Integrated' (Windows Authentication), or

  2. 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'.

SQL Server login

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:

Create SQL database

Leave the selection on 'Create', click 'Next'.

Note: In order to create new accounts you will need to have SA rights.

Add an account

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.

Create account in SQL

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.

Never delete Sample account

If you need to create more databases, simply select from the main menu File > New.

 

 

How Can We Help You?

Call Us (866) 226-5732
Contact Us Online
Schedule a call

Some of our clients:

Testimonials >>