While working on the 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. If you are using Sage 50 Canada and facing errors then reach out to Sage Support Canada.
- 1 Sage 50 Cannot Open the Database Because the Database Engine Reported An Error: Causes
- 2 Resolution for Sage 50 Database Engine Reported an Error
- 3 Get solutions to all of your accounting and bookkeeping problems with industry leading experts
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 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 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.
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 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 the 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 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.
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.
You need to take assistance from the 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 support phone number they will immediately connect with you. You can also choose a different means to connect with them through chat.