Sage 50 Cannot Open the Database Because the Database Engine Reported An Error

While working on the Sage 50, you can encounter certain errors and issues that may hamper your work efficiency. One such common error that you may come across while working on the program is Sage 50 Cannot Open the Database Because the Database Engine Reported An Error. It generally occurs in the Sage 50 Canadian edition.

If you are using Sage 50 Canada and facing errors then reach out to Sage Support Canada at 1800-865-4183.

Sage 50 Cannot Open the Database Because the Database Engine Reported An Error:

Causes

  • The database files are still in use by the Sage 50 application or any other third-party application.
  • Connection Manager is not the same. It is different for the workstation and the server.
  • The permission for the .SAJ directory does not have the complete system access.

Resolution for Sage Engine error:

In case, you are using the Sage 50 2018.x. then, you need to verify the following system requirements:

  1. Server 2008 R2 or higher versions.
  2. Microsoft Windows 7 or higher versions.
  3. Server 2008 SP2 is not similar to Server 2008 R2.

Solution I:

  • Restart the system after you have saved and ended all the application.
  • Check again whether you still receive the same notification.

Solution II:

  • Check whether the file is not opened on the same system.
  • Close one option of Sage 50 in such case.
  • Rename the .SAJ data folder by adding a number like 1 at the end of the .SAJ.
  • In case you are unable to access it, then it means data is locked.
  • Restart the system that has the Sage 50 Company files saved in it. It opens up the lock of the data.
  • In case, you are successful in doing so, it means that your data isn’t locked.
  • Rename the .SAJ data folder by adding a number like 1 at the end of the .SAJ.

If you are able to fix your issue then great, but if you are getting the same kind of an error i.e. Sage 50 cannot open the database then here is the next solution you can try.

Sage 50 Cannot Open the Database Because the Database Engine Reported An Error

Solution III:

  • Reboot your system.
  • Log in to the system as the Admin.
  • Uninstall the MySQL ODBC 3.51 from the system.
  • Now, install the MySQL ODBC 3.51.19 in your system.
  • Copy the Sage 50 Company files from the original location and paste it to a different location.
  • Open the recently copied files and see that you can open them easily.
  • If you can easily open them, copy those Sage 50 Company files and paste it back to its original folder.

Solution IV:

  • Verify that you can open other files on your system network.
  • In case, you are able to open the other files on your system then, you need to copy the .SAI file and .SAJ folder from your Sage 50 Company file to a different location like system’s desktop.
  • Open Sage 50 software and open the company files from the desktop.
  • In case you are able to open it, you will now have to create a new folder on the server as a shared folder that has the complete control permission.
  • You will now have to copy the same Sage 50 Company file to this newly created folder.
  • Check whether you can open the company files now.
  • If you are still unable to open them, run an Advance database to check for the errors.
  • You can also restore the file from the backup.

Reach us:

The solutions above will help you in resolving the Sage 50 Cannot Open the Database Because the Database Engine Reported An Error. If you have any doubts and queries or you have tried the solutions above but the error still persists then, you need to take assistance from the technical experts.

You can reach out to Askforaccounting.com for assistance. They provide round the clock assistance across the globe. You just have to give a call on their Sage tech support phone number 1800-865-4183 and they will immediately connect with you. You can also choose a different means to connect with them, i.e. you can visit their website for Sage chat support for more assistance options.

0/5 (0 Reviews)