The content in this article assumes that the server machine (the machine where the TaxCalc database is held) works. If TaxCalc does not work on the server, please see our article for Cannot connect to DB - Server machine.
Below will detail the steps to try and resolve this issue yourself in the most common sequence.
1. Are the services required turned on?
In order for the TaxCalc database to be visible to other computers, you need a service to be running on the server machine. To check this, please complete the below steps:
2. Is your firewall correctly configured?
The next thing to check is whether the firewall is blocking the application from connecting to the server. Can you try to temporarily disable the firewall and open TaxCalc on the client machine. If disabling the firewall fixes this, firewall rules need to be added for the ports that TaxCalc uses. You may need to look at the configuration of the firewall on the server and the local machine before attempting to close and re-open TaxCalc. For more information on firewall settings, please read both of the below articles:
3. Is the server available outside of TaxCalc?
If this still doesn’t work, we need to check if the client machine can see and speak to the server. To do this, please complete the below steps:
If you are unable to ping the TaxCalc server machine by name and IP address you will need to contact your IT department for further assistance.
4. Drag and drop connection file.
As a last resort to try and force the connection, you can complete the below steps via the Database Connection File. We would however recommend avoiding this as it is a short term fix and may mean that there are bigger connection issues at the site and information from your IT consultant/expert may be required.
If you have done this previously, it may be that the previous drag and drop db connection file had been fixed to the IP address instead of the name. Occasionally IP addresses can change so we would recommend using the servername instead. Can you go to the server, click on Start > Discovery Response Editor > Ensure that the details within this pop up window contains the server name instead of the IP address.
a) On the server machine
b) On the additional machine
Click on the drag and drop message at the bottom of the "Cannot Connect to Database" window, and you will see the window below. Find the database connection file (ASP_DB_Connection.txt) you created in Step 4 and drag and drop it onto this screen.
You should now be presented with the login screen where you will be able to log in as usual.
If the above mentioned steps do not resolve the issue, please contact the support team to discuss this further.