Skip to content
Sage Error 40960

Sage 50 Error 40960 is a database connection error. It is related to Sage 300 software. Users get the error message “Cannot access database.” The configuration for the database has to be corrected to resolve Sage error 40960. This issue can also be related to a connection with the database. Despite correct settings, some users have reported that they cannot connect to the database. We’ll be looking at solutions for all of these underlying problems in this article.

Note: We assume that you have all the latest updates installed for your version of Sage 300. If not, then we highly recommend that you install all the latest updates available. Also, please log in to both Windows and Sage 300 with an administrative account. Without administrative privileges, you won’t be able to make changes to the settings in windows.

Error Code Error 40960Developer:Sage Group
Error DescriptionError 40960:

Cannot Access Database

Software:Sage 50
CauseThe DNS Database Setup is pointing to the wrong serverApplies to:Windows
SymptomsEven When the settings are correct the user cannot to databasePossible SolutionDisable the security software and connect them to the database

Exact Error Shown While Facing Sage Error 40960

Error 40960: Cannot Access Database

Causes of Sage Error 40960

The Cause for Sage Error 40960 can be that a User is using a DNS to database setup points to the wrong server.

DSN Settings

The DSN (Database Source Name) settings need to be corrected.

To do so, follow the steps provided below:

  • Open the 32 bit DSN (Data Sources) settings
  • Click on the DSN used by Sage 300
  • Select Configure
  • Correct all the settings for the DSN
  • Click on Save
  • Now restart the system and resume using the software.

Solution : Resolve Connection Problem

To Solve Sage Error 40960 confirm to system DNS used in ODBC is the correct SQL Login credentials.

To know more read below:

Oftentimes, a simple connection problem with the database can cause errors. Strangely enough, there are many security software that blocks certain connections through specific ports. In such a case, it becomes difficult to diagnose the underlying issue.

The easiest way to troubleshoot this issue is to simply disable each of the security software, and then try connecting to the database.

Most probably, the underlying cause of error for most connection problems such as Sage 50 error 40960 is windows firewall.

If this is the case, then follow the steps provided below:

  1. Disable firewall and check if you still get Sage error 40960
  2. If yes, then go to Advanced Settings for windows firewall
  3. Click on Inbound Rules and create a new rule for the port through which Sage connects to the database
  4. Do the same for Outbound rules
  5. Save name and description of these rules for future reference.

What is Sage 300?

Sage 300 is the flagship ERP (Enterprise Resource Planning) software offered by the Sage group. With this, you can manage:

  • Accounting
  • Manufacturing
  • Distribution
  • Inventory
  • Payments
  • Sales

It covers the entire landscape of business and enables you to micromanage and micro-analyze everything related to your business. This is a great software for planning your entire financial year. Further, once you’ve collected enough data, you can always analyze it with reporting tools and gain valuable insights. There are multiple plans available for Sage 300, which make it highly customizable. You can choose the plans and versions according to your business requirements.

How can AccountingErrors Help You?

Diagnosing and fixing errors, sometimes requires knowledge of the software, windows, and database. Not every organization can hire people who specialize in all three.

Our round the clock Sage tech support helpdesk is available through:

  • Chat
  • Email
  • Call

Was this worth your time?

This helps us sort answers on the page.

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate this post.

Leave a Reply

Your email address will not be published.

Disclaimer : We are a third party agency working on providing authentic support and full fledged services for for accounting software QuickBooks 2018 version. It is one of… Read more