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

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

While working on Sage 50, you can encounter certain errors and issues that may hamper your work efficiency. One such Sage 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.

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

If you are experiencing problems opening the Sage 50 database, there may be a reason for it. One possible cause is that the Database Engine reported an error.

  • 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 complete system access.

Resolution for Sage 50 Database Engine Reported an Error

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

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

Total Time: 37 minutes

Solution 1: Restart System After Ending all Application.

๐Ÿ”น Restart the system after you have saved and ended all the applications.
๐Ÿ”น Check again whether you still receive the same notification.

Solution 2: Rename the .SAJ Data Folder

๐Ÿ”น Check whether the file is not opened on the same system.
๐Ÿ”น Close one option of Sage 50 in such a 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 can fix your issue then great, but if you are getting the same kind of error i.e. Sage 50 cannot open the database then here is the next solution you can try.

Solution 3: Uninstall MySQL ODBC 3.51 & Install MySQL ODBC 3.51.19

๐Ÿ”น 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 them 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 them back to their original folder.

Solution 4: Copy .SAI file and .SAJ folder from Your Sage 50 Company file

๐Ÿ”น Verify that you can open other files on your system network.
๐Ÿ”น In case, you can 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 the systemโ€™s desktop.
๐Ÿ”น Open Sage 50 software and open the company files from the desktop.
๐Ÿ”น In case you can open it, you will now have to create a new folder on the server as a shared folder that has 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 errors.
๐Ÿ”น You can also restore the file from the backup.

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 persists.

You need to take assistance from technical experts. You can reach out to AskForAccounting for assistance. They provide round-the-clock assistance across the globe. You just have to give a call to their Sage 50 Consultant phone number they will immediately connect with you. You can also choose a different means to connect with them through chat.

Get solutions to all of your accounting and bookkeeping problems with industry leading experts

call to action img

Call Now
Chat Now

Phone

+1-347-967-4078