Sage is a prominent solution for handling business-related activities and comes up with numerous features and functionalities. However, users may come across different error codes while accessing Sage. Today, we are writing on one such error ‘Sage Error 40960” that is related to Sage 300 and appears because of incorrect DNS settings.
This article contains the root causes of the error 40960 and solutions to get rid of it. If you have any doubts regarding this post or want an expert’s advice, visit our website.
What is Sage Error 40960?
Sage Error 40960 is related to Sage 300 and a database error usually comes across when you are failed to connect to the database. You first need to configure the database to get rid of the error 40960 Sage. Even after configuring the database settings, this error has been reported by many users. You may also get the same issue because of an incorrect server while using a Data Source Name (DSN), you may experience the Sage error 40960. Check out the whole post to find out appropriate solutions.
Also Read: How to Resolve Sage Error Code 1923?
What are the Solutions to Fix Sage Error Code 40960?
Assumingly, you have already installed all the recent launches related to Sage 300. Because this can be the reason behind the error 40960. Also, make sure that you have logged in to the Sage 300 software as an Admin.
Now, go ahead to apply the underneath solutions.
Solution 1: Check DNS Settings
- Firstly, launch the 32 bit DSN settings.
- Next, choose the DSN by using Sage 300.
- After that, click on Configure and correct all DSN settings.
- Lastly, choose Save.
Solution 2: Fix the Connection Issue
It may be seen that Sage error 40960 usually occurs because of a connection issue with the database. There can be various security software that may block certain connections via specific ports. In such a scenario, the best way to deal with the issue is to disable the security software. After that, you can connect to the database.
Now, look into the following steps to get rid of connection errors.
- First of all, disable the firewall and check whether the Sage error 40960 has been fixed.
- If the issue has been fixed, choose the Advanced Settings for Windows Firewall.
- After that, choose Inbound Rules and create a new rule for the port by which Sage connects to the database.
- Perform the same steps for Outbound Rules.
- Finally, save the name and description.
We expect that this post contains the required information regarding Sage error 40960. It is highly recommended to update the Sage 300 before heading for any of the aforementioned solutions. If you are still struggling with the same issue and failed to resolve it, immediately contact us to hire an expert who can resolve all your queries related to Sage. We have a team of certified experts who knows well how to resolve such technical glitches associated with Sage.