Knowledgebase Support HMRC Useful links
Knowledgebase home
Tax Return Production
Accounts Production
Client Hub
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
For Accountancy Practices and Tax Advisors For Individuals, Businesses, Trusts, and Partnerships
PRACTICE MANAGEMENT
Client Hub
Companies House Integration
GDPR Centre  
NEW

eSign Centre  
NEW

AML Identity Checking


COMPANY SECRETARIAL
Company Incorporator
Companies House Forms
FINANCIAL REPORTING
Accounts Production


TAXATION AND HMRC
Tax Return Production
VAT Filer


SERVICES
CloudConnect
TAX SOFTWARE
Individual
Limited Company
Partnership
Trust
VAT SOFTWARE
VAT Filer for Business  
NEW

Database connection details not found (Cannot connect to database)

Article ID: 1246
Last updated: 05 Jul, 2018

If TaxCalc loses contact with, or has never been able to connect to a database, you will receive the following error message (The wording in the top panel may differ slightly).

This means that your additional machine cannot ‘see’ the server machine – the one on which the database is installed. You can fix this by creating a connection file, as follows.

Step 1: On the server machine

  1. On the machine on which the database is installed, click on the Windows Start button.
  2. Select All Programs and then the TaxCalc Hub folder.
  3. Click on the Discovery Response Editor program. The following window will open.

  1. Click on Create Database Connection File....
  2. Save the database connection file (ASP_DB_Connection.txt) somewhere that can be accessed from the additional machine.

Step 2: On the additional machine

Click on the drag and drop message at the bottom of the error window, and you will see the drag and drop window. Find the database connection file you created in Step 1 and drag and drop it onto the error message box (pictured below).

You should now be able to log in as usual.

Please Note; This information is only applicable to Additional machines not the one acting as the TaxCalc server. If you have issues on the Server computer itself. It is likely that the PostgreSQL service is not started. See Postgres does not always start when the "server" machine is rebooted for more information.

Firewall problems

If you still can't log in, you may be presented with the same messaging as per the first screenshot in this article.

This most likely means that there's an issue with the firewall settings on one or both machines.

To fix this, you need to open the following ports through your firewall:

  • 5433 or 5432 (PostgreSQL could be using either port depending on your configuration, If in doubt add both ports)
  • 3838
  • 6178.

Firewall test

Before opening the firewall ports, you can try temporarily disabling the firewall completely. However, this test is entirely at your discretion as disabling a firewall always carries a risk.

If the database connection can be made while the firewall is disabled, the problem is definitely with the firewall.

Re-enable the firewall and open the ports listed above correctly, using the guidance for your specific firewall. This should solve the connection problem.

If you need more help with firewalls, read the following:

Article ID: 1246
Last updated: 05 Jul, 2018
Revision: 18
Views: 17665
This article was:  


Also read
item Postgres does not always start when the "server" machine is rebooted