Resolve Sage 50 Database Error: Ddatabase engine on computer [server] is Unavailable

Sage 50 error “your database engine on computer [server] is unavailable” occurs because of network issues or database manager errors. Sage 50 won’t be able to connect with the data file if the Actian service isn’t even operating, which will result in a problem. Sage 50 database engine errors are one of the most common errors you may face, it occurs due to firewall authentication blocking connection manager or Sage folder issues. In this post, you’ll learn how to fix the Sage 50 error connecting to the database.

The exact error message is shown…

Error: “Your database engine on computer computer name is unavailable”

Causes of Sage 50 Cannot Connect to its Database Error

There are certain causes of Sage 50 database engine error, all are listed below:

• This error may occur when you find the necessary file is missing from the SAJ folder.
• If Mysqld.exe, Mysqld-nt.exe, or anti-virus finds any threat that is related to a deleted file or folder may create this error issue.
• When firewall authentication blocks the connection manager, this error appears on your screen.
• When you are not able to log into services in Windows, this error causes the effects.
• Issues with the .NET framework and corrupted, deleted, or damaged files.
• When your account face server shares all necessary data permission location issues, this error will disturb your whole work.

6 Solutions for Sage 50 Error Connecting to the Database

Start with the solutions, to eliminate the root causes of the error, and proceed with each remedy in the sequence given. Use an admin account in Windows to repair this problem since many of the tasks in these solutions demand admin capabilities.

Solution 1: Verify the data path

When Sage 50 is launched, an incorrect data route may prohibit it from accessing the data. The Sage 50 issue connecting to the database is the outcome of this. To resolve this issue, you can check to make sure the data is kept in the appropriate data path.

Here are the steps to locate the company file directory:

• How to find the location of your company file:
  • Choose Maintain from the main menu.
  • Click on company information.
  • Select the Directory option to expand it so that you can view the full location of your company file.
• How to locate a remote data access company:
  • From the left panel, choose the Systems option.
  • Click on Company Maintenance.
  • View and note the location of the data file/company file.
• How to find the location through the new company screen:
  • From the File option, choose Open Company.
    Note: you’ll find all company files listed here.
  • Click on Open an existing company file.
  • View the directory where the company file is stored.
• How to locate the company file with File Explorer:
  • Press Windows + E, to launch the File Explorer.
  • From the top right corner, click on the Search field.
  • Select the option All Files and Folders.
  • Enter COMPANY.DAT  in the search field, and hit enter.
  • In the view option for Windows Explorer, choose Detail so that all the appropriate details about the files are displayed in corresponding columns.
  • View and note the directory where the company file is saved.

Here are the steps that you can use to find the location of the program path in Sage 50:

• Launch Windows File Explorer.
• Go to the following directory: C:\ProgramData\Sage\Peachtree.
• Launch the Configuration File by double-clicking on it.
• From the list of programs, choose Notepad as the default program to open this file type, then click on Ok.
• In the notepad, find the DATAPATH= line and note the directory where the company file is saved.
• In the notepad, find the PROGRAMPATH= and note down the program path of Sage 50.

Solution 2: Change network profile to private

The Sage 50 installer sets up a Windows Firewall to allow connections for Sage 50 when you install Sage 50 for the first time. The firewall rules produced by the installer won’t function as planned, though, if you’ve set the Sage 50 network to the public. As a result, you must configure Sage 50’s network to be private.

Steps to change network profile to fix Sage 50 error connecting to the database:

• Click on the Start menu icon, and type Control Panel.
• Choose the Control Panel option.
• From the listed options, choose Network and Internet Settings.
• Change the settings from Public to Private.
• From the Network profile options, click on Private to change network preference. 
• Choose the settings option, and then click on Test Connectivity to ensure that your network connection works despite changing the network settings.

If you still get the Sage 50 error “Your database engine on computer [server] is unavailable”, then move to the solution provided below.

Solution 3: Create custom rules for Windows Firewall

To rapidly create exceptions for Sage 50, it is simple to establish customized firewall rules. You don’t get the Sage 50 issue linking to the database when Sage 50 can connect to the company file.

You must have administrator privileges to create custom firewall rules on Windows. Furthermore, to follow these instructions, you’ll need to have extensive operating system understanding.

• In the Start menu’s search bar, type in Windows Defender Firewall. Then hit enter.
• Choose the Advanced Settings from the left panel.
• Click on the Inbound Rules option that is given in the left pane.
• Move your mouse to the right pane, and Choose New.
• Select the radio button against Port, then click on Next.
• Enter the specific Port numbers assigned to your version of Sage 50 accounting software, and then click on Next.
• From the available options, choose the ratio button against Allow the connection, and then click on Next.
• Choose Private as the Domain Option, and then choose Next.
• Enter a descriptive name for the firewall rule, a name such as “Sage 50 accounting inbound.
• Click on Finish.
  Note: these descriptive names help you to identify the custom rules that you create in the future.
• Go through the same steps to create an Outbound Rule instead of an inbound rule.

You have made Sage 50 an exception to both the incoming and outgoing rules, enabling it to connect to the corporate file that is kept on a different server.

Solution 4: Reinstall Actian to repair its program files

The database management system used to maintain the data in Sage 50 corporate files is called Actian. Action updates the database and records the necessary modifications each time you complete a job in Sage 50. Sage 50 relies on Actian to interact with the database, thus if Actian files are corrupted, Sage 50 won’t be able to connect to the database.

Steps to uninstall Actian from your server:

• Either close Sage 50 and all its instances or restart your server system.
• Press Windows + R to open the run too.
• In the text field, enter AppWiz.cpl. Hit Enter.
• Choose Actian PSQL v13 Workgroup R2 from the Programs & Features window.
• From the toolbar above, click on Uninstall.
• When the installation wizard appears, follow the instructions provided to uninstall Actian completely from your system. 
• Restart your system after you’ve uninstalled the action from the system.
• Delete the pvswarch and pvsw folders from the C drive.
• Further, delete the following files from the C drive:
  • pvsw.log file 
  • PSQL_v[version number os Sage 50]_Install.log file.
• Remove the Pervasive Software folders from Program Files and Program Files (x86) folders.
• Press Windows + R to open the run command again.
• Input regedit in the text field once again, and hit enter.
• On the Computer option, hover the mouse and right-click. Then choose the Export option to create a backup of the Windows registry, which can be restored if you accidentally delete an essential Windows registry.
• Browse to HKEY_LOCAL_MACHINE\Software and delete the Pervasive Software and PEYX489ZK.
• Close the Registry Editor.

Steps to reinstall Actian in Windows:

• Press Windows + E and the File Explorer window will appear.
• Browse to C:\Sage\Sage50_[version]. Or go to the location where you installed Sage 50.
• Go to the PervasiveMin folder and launch the SetupGroup32_x82.exe. Then click on Next.
• After accepting the license agreement, click on Next.
• Click on Complete, then on Next.
• Click on Install, to begin the installation of actian on your system.
• Click on Finish once the installation completes, then restart your system.

Actian, Sage 50’s main database management system, has been successfully restored. If any Actian files were harmed in the past, they would already have been fixed. So that you may access your company file in Sage 50.

Solution 5: Check for damage to the WMI file

Windows needs WMI files to conduct several operations. Various script languages won’t run on Windows if the file is destroyed.

Steps to check if the WMI file is damaged

• Press Windows + R to launch the run command.
• Input eventvwr into the text field, and hit enter.
• From Windows Logs, Choose the option titled Application.
• For WMI files, view the references provided on the screen.
• Get in touch with IT professionals in our team if you find WMI files mentioned in the error logs.

Solution 6: change preference for Internet protocol

You must make IPv4 the primary network protocol on Windows since IPv6 may damage certain of its components. Because there are fewer steps involved, changing settings via the registry is simpler.

Steps to change network protocol preference from IPv6 to IPv4:

• Use an admin account to log into Windows.
• Press Windows + R to open the run command.
• Input Regedit in the text field, and hit enter.
• From the left pane, navigate to HKLM\SYSTEM\CurrentControlSet\Services\Tcpip6\Parameters.
• Choose the New Key option to create a new registry key.
• Fill in the following information required for creating a new key option:
  • Key: DisabledComponents
  • Type: REG_DWORD
  • Value: 0x20

Sage 50 will now use the IPv4 connection protocol to connect to the business file saved on the server because you’ve successfully disabled IPv6 in Windows. As an alternative, you may look for a data path and program path in Sage 50 using another business file.

Steps to find program and data paths from Sage 50:

• Launch Sage 50.
• Once the program opens, log into a Locally stored Company File.
• From the File option, click on Open Company.
• Note down the directory for the data path.
• Type Sage 50 in the Start menu, and right-click on the Sage 50 icon.
• Choose Properties and note down the program directory.

If you still receive the  “Your database engine on computer [server] is unavailable” error, then check your internet connection, and ensure that it’s working.

Conclusion

By using the suggestions in this post, I hope you were able to resolve the Sage 50 error “Your database engine on computer [server] is unavailable”. I’ve included a thorough, step-by-step tutorial for investigating and resolving this problem. Ask your system administrator if you don’t already have an admin account, as the majority of these remedies need you to have administrator permissions in Windows.

FAQ’s