Knowledgebase Support HMRC Useful links
Knowledgebase home
Tax Return Production
Accounts Production
Practice Management
VAT Filer
CloudConnect
Anti-Money Laundering
Support home
Hot Topics
SimpleStep Guides
Release Notes
Technical
Known Issues

HMRC Status
Useful Links
MTD for Agents MTD for Businesses What is MTD
Preparation
Agent Services Account
MTD for VAT
MTD for Income Tax
MTD for VAT
Digital Record Keeping
Quarterly Updates
Step-by-step Guide
HMRC's MTD Timeline
TaxCalc's MTD Journey

Moving TaxCalc to a new server (Practice - Network version)

Article ID: 2215
Last updated: 06 May, 2020

The steps to move TaxCalc to a new server are outlined below.

While the process is reasonably straightforward, TaxCalc can perform this move for customers but it is a chargeable option. Please speak to Support for more detail if you wish us to undertake moving the program to a new server for you.

Make a backup (existing Server)

To make a backup on the existing PC, go to Hub – Administration – Database.

Choose Backup Database and then select a destination on the local machine for the backup file to be saved. Once the backup has completed you can then transfer the backup file onto media that you can copy to the new PC (maybe a memory stick or removable hard drive or copied to a shared network). 

Uninstall the program (existing Server)

Uninstall TaxCalc and the TaxCalc Discovery Service while connected to the internet. This will remove the program from the online registration and will prevent any issues when loading onto the new server.

IMPORTANT  uninstalling TaxCalc does not remove the actual data files from the old PC, just the program files. Data is left intact.

Disable PostgreSQL, go to START > Search. Type services.msc in the search box. Scroll down to the services starting with P, PostgreSQL 9.4 should be shown. Right-click and choose Properties. Stop the service then set Startup type to Manual. If PostgreSQL9.0 also appears, then do the same with that.

PLEASE NOTE – if you do not uninstall the programs from the existing server and disable PosgreSQL, then the database engine and the Acorah Discovery Service remains active. This may mean that client PCs could continue to connect to the old server, leading to database mismatches. If you use PostgreSQL for other databases, please contact TaxCalc support for assistance before disabling the service.

Install the TaxCalc software (NEW Server)

Download and install the program from the TaxCalc website as follows.

  • Go to www.taxcalc.com and log on using your website credentials.
  • Click on My Account (next to the login box) which takes you to the download page.
  • Click Download to get TaxCalc.
  • In order to download the file again, tick the box that says 'I understand…' then select Download.
  • When the file is complete, double-click on the downloaded file and the installation will start. During the installation, leave all the options at the default.
    • Postgres users will be asked to create a root database password – this is used for the database engine (it is not related or connected to the admin or website logins). You must remember this password.
  • Once the program is loaded, run it once to make sure it is working.

PLEASE NOTE: – if you get an 'invalid mac address' message when trying to install on the new machine, please contact Support. This notes that TaxCalc records indicate that the software may already be installed on the maximum number of machines for that account.

Can I store the Postgres database on a remote drive or NAS box?

Restore the backup (NEW Server)

Insert the memory stick or backup hard drive (upon which the the backup made earlier is saved) into the new server.

  • Open TaxCalc.
  • Go to Administration – Backup.
  • Restore the backup.

At this stage, if you have a Postgres database, you will be prompted for the root database password. This is the password used when installing the program on the new PC. It is not the admin, website or previous (old) machine's root database password.

The server portion of the installation is now complete.

Make sure the workstations connect to the database on the new server

Once the program is successfully installed and running on the server, the client PCs need to be checked to make sure they can connect to the server.

In most cases simply starting the client PC’s version of TaxCalc should allow the machine to connect to the database without a problem, however on occasion users may get the following:

  • A list of two (or more!) databases with the prompt to choose one.
  • A 'db_connection error' message appears prompting the user to drag the db_connection file onto the error message.

More than one database appears

If more than one database is shown it is likely that the Acorah Discovery Service is still running on the old server, allowing a connection to the old database. Please ensure TaxCalc is removed from that computer. If it is already removed then it may be necessary to stop the Acorah Discovery Service and set it to manual so it doesn’t start again.

To do this, go to START – Search. Type services.msc in the search box. The Acorah Discovery Service should be at/near the top. Right-click and choose Properties. Stop the service then set Startup type to Manual.

'db_connection error' appears

If a 'db_connection error' occurs then it is possible that the Acorah Discovery Service is either not running on the new server or that it is being blocked somewhere.

Restart the Acorah Discovery Service and try again.

If this fails then go to the server and create the db connection file as outlined in the article below.

Troubleshooting your Database connection (Practice users)

Article ID: 2215
Last updated: 06 May, 2020
Revision: 16
Views: 5838
This article was:  


Also read
item Cannot connect to database error message appears when starting TaxCalc

Also listed in
folder Technical -> Moving TaxCalc