{"id":4361,"date":"2022-06-13T07:37:01","date_gmt":"2022-06-13T07:37:01","guid":{"rendered":"http:\/\/localhost\/localerrors\/dup-installer\/?p=4361"},"modified":"2025-02-24T09:27:45","modified_gmt":"2025-02-24T09:27:45","slug":"sage-50-error-connecting-to-database","status":"publish","type":"post","link":"https:\/\/www.bigxperts.com\/sage\/sage-50-error-connecting-to-database\/","title":{"rendered":"Fix Sage 50 Error Connecting to Database"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Sage 50 cannot connect to its database because of underlying errors. If the Actian service isn\u2019t running in the first place, then Sage 50 won\u2019t be able to communicate with the data file, leading to the error. Further, various security programs such as Windows Firewall can cause this error. In rare cases, incorrect data path and program path in Sage 50 can lead to failure of communication with the database. When trying to fix this issue, it is important to proceed methodically so that you can eliminate underlying causes while troubleshooting the error.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In this post, you\u2019ll learn how to fix the Sage 50 error connecting to the database.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Error<\/strong>: &#8220;Sage 50 cannot connect to its database, Actian Zen on computer [server].&#8221;<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_83 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Post Navigation<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 eztoc-toggle-hide-by-default' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.bigxperts.com\/sage\/sage-50-error-connecting-to-database\/#causes-of-sage-50-cannot-connect-to-database\" >Causes of Sage 50 Cannot Connect to Database<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.bigxperts.com\/sage\/sage-50-error-connecting-to-database\/#solutions-for-sage-50-error-connecting-to-the-database\" >Solutions for Sage 50 Error Connecting to the Database<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.bigxperts.com\/sage\/sage-50-error-connecting-to-database\/#solution-1-verify-the-data-path\" >Solution #1: Verify the Data Path<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.bigxperts.com\/sage\/sage-50-error-connecting-to-database\/#solution-2-change-network-profile-to-private\" >Solution #2: Change Network Profile to Private<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.bigxperts.com\/sage\/sage-50-error-connecting-to-database\/#solution-3-create-firewall-rules-for-sage-50\" >Solution #3: Create Firewall Rules for Sage 50<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.bigxperts.com\/sage\/sage-50-error-connecting-to-database\/#solution-4-reinstall-actian-on-the-server\" >Solution #4: Reinstall Actian on the server<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.bigxperts.com\/sage\/sage-50-error-connecting-to-database\/#solution-5-check-for-damage-to-the-wmi-file\" >Solution #5: Check for Damage to the WMI File<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.bigxperts.com\/sage\/sage-50-error-connecting-to-database\/#solution-6-change-preference-for-internet-protocol\" >Solution #6: Change Preference for Internet Protocol<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.bigxperts.com\/sage\/sage-50-error-connecting-to-database\/#conclusion\" >Conclusion<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.bigxperts.com\/sage\/sage-50-error-connecting-to-database\/#faq\" >FAQ<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"causes-of-sage-50-cannot-connect-to-database\"><\/span>Causes of Sage 50 Cannot Connect to Database<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Sage 50 error connecting to the database can occur because of a few reasons if the backup is still not completed and a file was left open in the background.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The SAJ folder must have a read-only attribute.<\/li>\n\n\n\n<li>The Antivirus service is detecting mysqld.exe, myself-nt.exe, or Connection Manager service as threats and thus sent to quarantine.<\/li>\n\n\n\n<li>Windows Firewall service is probably blocking the Connection Manager which as a result is not able to connect to the database engine.<\/li>\n\n\n\n<li>.NET Framework can also create conflicts.<\/li>\n\n\n\n<li>Connection Manager is not properly installed or the service has not started on a server.<\/li>\n\n\n\n<li>There can be issues with permission with the shared data location on a server.<\/li>\n\n\n\n<li>Using a UNC address can also cause issues.<\/li>\n\n\n\n<li>Corrupted data can bring problems connecting to the database.<\/li>\n\n\n\n<li>If SAJ and SAI are stored in Dropbox, Google Drive, or OneDrive then it can create conflicts<\/li>\n\n\n\n<li>The Actian Zen has Stopped on the Server<\/li>\n\n\n\n<li>The Network Location Profile on the Server or Workstation  has been set to Public instead of Private<\/li>\n\n\n\n<li>The Data path on the Workstation is Incorrect.<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-verse\"><strong><em>Read More<\/em><\/strong>: <a href=\"https:\/\/www.bigxperts.com\/sage\/sage-50-cannot-open-the-database-or-company-file\/\">Fix Sage 50 Can' t Open Company Database<\/a><\/pre>\n\n\n\n<h2 class=\"wp-block-heading block-less-h2\"><span class=\"ez-toc-section\" id=\"solutions-for-sage-50-error-connecting-to-the-database\"><\/span>Solutions for Sage 50 Error Connecting to the Database<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Let\u2019s get started with the solutions. Proceed with each solution in the order provided so that you can eliminate the underlying causes of the error. Also, you will require admin rights to perform many of the actions in these solutions, so use an admin account in Windows to fix this error.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"solution-1-verify-the-data-path\"><\/span>Solution #1: Verify the Data Path<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">An incorrect data path can prevent Sage 50 from accessing the data when you launch the program. The result of this is the Sage 50 error connecting to the database. However, you can verify that the data is stored in the correct data path to fix this problem.&nbsp;<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">A. Steps to locate the company file directory:<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Steps for locating an open company file:<\/strong>\n<ul class=\"wp-block-list\">\n<li>Click on <strong>Maintain <\/strong>from the main menu.<\/li>\n\n\n\n<li>Choose <strong>company information<\/strong>.<\/li>\n\n\n\n<li>Click on <strong>Directory <\/strong>to find the location of your company file.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Steps to locate a remote data access company.<\/strong>\n<ul class=\"wp-block-list\">\n<li>Choose the <strong>Systems option <\/strong>from the left panel.<\/li>\n\n\n\n<li>Choose <strong>Company Maintenance<\/strong>.<\/li>\n\n\n\n<li><strong>Note down <\/strong>the location of the company file.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Steps to locate from the New Company screen:<\/strong>\n<ul class=\"wp-block-list\">\n<li>Go to the <strong>File option<\/strong>.<\/li>\n\n\n\n<li>Choose <strong>Open Company<\/strong>.<\/li>\n\n\n\n<li>Choose <strong>Open an existing company file<\/strong>.<\/li>\n\n\n\n<li><strong>Note down <\/strong>the location from the Directory column.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Steps to locate with file search in Windows:<\/strong>\n<ul class=\"wp-block-list\">\n<li>Open <strong>File Explorer<\/strong>.<\/li>\n\n\n\n<li>Click on the <strong>Search field <\/strong>in the top right corner of the window.<\/li>\n\n\n\n<li>Choose <strong>All Files and Folders<\/strong>.<\/li>\n\n\n\n<li>Input <strong>COMPANY.DAT <\/strong>and hit <strong>enter<\/strong>.<\/li>\n\n\n\n<li>Choose <strong>Detail <\/strong>as the view option for Windows Explorer.<\/li>\n\n\n\n<li>Note the <strong>location <\/strong>of the company file from the Folder column.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Steps to locate company files through Windows registry.<\/strong>\n<ul class=\"wp-block-list\">\n<li>Press <strong>Windows + R<\/strong>.<\/li>\n\n\n\n<li>Input <strong>Regedit <\/strong>and hit <strong>enter<\/strong>.<\/li>\n\n\n\n<li>From the left panel, browse to <strong>HKEY_CURRENT_USER\\Software\\Peachtree\\Version<\/strong>.<\/li>\n\n\n\n<li>Expand the <strong>key <\/strong>for your version of Sage 50.<\/li>\n\n\n\n<li>Choose <strong>Open History<\/strong>.<\/li>\n\n\n\n<li>Choose the <strong>flavor folder <\/strong>beneath the open history option.<\/li>\n\n\n\n<li>From the right panel, <strong>note down the location <\/strong>of the company file available in the Data column.<\/li>\n\n\n\n<li>Close the <strong>Registry Editor<\/strong>.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">B. Steps to locate the data and program paths for the Sage 50 company file:<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Open the <strong>File Explorer<\/strong>.<\/li>\n\n\n\n<li>Go to <strong>C:\\ProgramData\\Sage\\Peachtree<\/strong>.<\/li>\n\n\n\n<li>Double-click on the <strong>Configuration File <\/strong>for Sage 50.<\/li>\n\n\n\n<li>Choose <strong>Notepad <\/strong>as the program and hit <strong>OK<\/strong>.<\/li>\n\n\n\n<li>Find <strong>DATAPATH=<\/strong>, and note down the data path of the company file.<\/li>\n\n\n\n<li>Find <strong>PROGRAMPATH=<\/strong>, and note down the program path of Sage 50.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"solution-2-change-network-profile-to-private\"><\/span>Solution #2: Change Network Profile to Private<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">When you install Sage 50 the first time, the installer configures Windows firewall to not block connections for Sage 50. However, if you\u2019ve set the Sage 50 network to the public, then the firewall rules created by the installer won\u2019t work as intended. So you need to set the network as private for Sage 50.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">A. Steps to change network profile to fix Sage 50 error connecting to the database<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Go to the <strong>Start <\/strong>menu and open the <strong>Control Panel<\/strong>.<\/li>\n\n\n\n<li>Go to the <strong>Network Profile <\/strong>option, and choose <strong>Private<\/strong>.<\/li>\n\n\n\n<li>Go back and click on <strong>Settings<\/strong>.<\/li>\n\n\n\n<li>Choose <strong>Test connectivity<\/strong>.<\/li>\n\n\n\n<li>Try to open the company file.<\/li>\n<\/ul>\n\n\n\n<ol class=\"wp-block-list\"><\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">If you still get the Sage 50 error connecting to the database, then move on to the next solution.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"solution-3-create-firewall-rules-for-sage-50\"><\/span>Solution #3: Create Firewall Rules for Sage 50<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Creating custom firewall rules is an easy method to quickly create exceptions for Sage 50. When Sage 50 can connect to the company file, you don\u2019t get the Sage 50 error connecting to the database.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><strong>Note<\/strong>: you need admin rights to make custom firewall rules in windows. Further, you\u2019ll require advanced knowledge of the operating system so that you can follow through with these instructions.<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Steps to create firewall rules for Sage 50:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Go to the <strong>Start <\/strong>menu.<\/li>\n\n\n\n<li>Type in <strong>Windows Defender<\/strong> firewall.<\/li>\n\n\n\n<li>From the left panel, choose <strong>Advanced Settings<\/strong>.<\/li>\n\n\n\n<li>Choose <strong>Inbound Rules<\/strong> from the left pane.<\/li>\n\n\n\n<li>Choose <strong>New <\/strong>from the right pane.<\/li>\n\n\n\n<li>Choose <strong>Port<\/strong>, then <strong>Next<\/strong>.<\/li>\n\n\n\n<li>Input the <strong>Port numbers <\/strong>for your version of Sage 50. Then click on Next.<\/li>\n\n\n\n<li>Choose to <strong>Allow the connection<\/strong>, then <strong>Next<\/strong>.<\/li>\n\n\n\n<li>Set the <strong>Domain option <\/strong>as <strong>Private<\/strong>, and click on <strong>Next<\/strong>.<\/li>\n\n\n\n<li>Input \u201c<strong>Sage 50 accounting inbound<\/strong>\u201d, then select <strong>Finish<\/strong>.<br><strong>Note<\/strong>: if you don\u2019t input a descriptive name for the rule, you may not be able to identify the rule in the future.<\/li>\n\n\n\n<li>Follow the same steps to create an <strong>Outbound rule<\/strong> for Sage 50.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">With both inbound and outbound rules, you have created an exception for Sage 50, so now it can connect to the company file stored on a separate server.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"solution-4-reinstall-actian-on-the-server\"><\/span>Solution #4: Reinstall Actian on the server<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Action is the database management system that manages the data in Sage 50 company files. Whenever you perform a task in Sage 50, Actian communicates the changes to the database and stores the required changes. If Actian files are damaged, you\u2019re going to get the Sage 50 error connecting to the database because Sage 50 relies on Actian to communicate with the database.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">A. Steps to uninstall Actian from your server.<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Close <\/strong>all instances of Sage 50 running on your server.<br><strong>Note<\/strong>: ask all users to log out before you close Sage 50; otherwise, the changes made to data won\u2019t be stored.<\/li>\n\n\n\n<li>Press <strong>Windows + R <\/strong>and enter AppWiz.cpl in the input box. Hit Enter.<\/li>\n\n\n\n<li>In the <strong>Programs &amp; Features <\/strong>window, right-click on <strong>Actian PSQL v13 Workgroup R2<\/strong>.<\/li>\n\n\n\n<li>Choose <strong>Uninstall <\/strong>and follow the on-screen instructions to remove Actian from Windows.<\/li>\n\n\n\n<li>Go to the <strong>C Drive <\/strong>and delete the <strong>pvswarch <\/strong>and <strong>pvsw <\/strong>folders.<\/li>\n\n\n\n<li>Further, delete the pvsw.log file and PSQL_v[version number os Sage 50]_Install.log file.<\/li>\n\n\n\n<li>Remove the Pervasive Software folders from <strong>Program Files <\/strong>and <strong>Program Files (x86) <\/strong>folders.<\/li>\n\n\n\n<li>Press <strong>Windows + R <\/strong>input <strong>regedit<\/strong>, and hit <strong>enter<\/strong>.<\/li>\n\n\n\n<li>Right-click on <strong>Computer<\/strong>, then choose <strong>Export <\/strong>to save a backup of your registry, which may be required later if something doesn\u2019t work properly.<\/li>\n\n\n\n<li>Browse to <strong>HKEY_LOCAL_MACHINE\\Software <\/strong>and delete the <strong>Pervasive Software <\/strong>and <strong>PEYX489ZK<\/strong>.<\/li>\n\n\n\n<li>Exit Windows <strong>Registry Editor<\/strong>.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">B. Steps to reinstall Actian in Windows:<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Press <strong>Windows + E<\/strong> to launch File Explorer.<\/li>\n\n\n\n<li>Go to <strong>C:\\Sage\\Sage50_[version] <\/strong>or the custom location that you chose to install the software in.<\/li>\n\n\n\n<li>Go to the <strong>PervasiveMin <\/strong>folder and launch the <strong>SetupGroup32_x82.exe<\/strong>. Then click on Next.<\/li>\n\n\n\n<li><strong>Accept <\/strong>the terms of service, then click on Next.<\/li>\n\n\n\n<li>Click on <strong>Complete<\/strong>, then Next.<\/li>\n\n\n\n<li>Choose <strong>Install<\/strong>, then <strong>Finish <\/strong>after the installation finishes.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">You\u2019ve successfully reinstalled Actian, the primary database management system used by Sage 50. If any Actian files were damaged, they would have been repaired by now.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"solution-5-check-for-damage-to-the-wmi-file\"><\/span>Solution #5: Check for Damage to the WMI File<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">WMI files are necessary for Windows to run various functions. If the file is damaged, various script languages won\u2019t run on Windows. Damage to a WMI file can be one reason for getting the Sage 50 error connecting to the database.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Steps to check if the WMI file is damaged:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Press <strong>Windows + R<\/strong>.<\/li>\n\n\n\n<li>Input <strong>eventvwr <\/strong>and hit <strong>enter<\/strong>.<\/li>\n\n\n\n<li>Go to <strong>Windows Logs<\/strong>, then choose <strong>Application<\/strong>.<\/li>\n\n\n\n<li>View references for <strong>WMI files<\/strong>.<\/li>\n\n\n\n<li>Contact our <strong>IT professionals <\/strong>if you find WMI files mentioned in the error logs.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"solution-6-change-preference-for-internet-protocol\"><\/span>Solution #6: Change Preference for Internet Protocol<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">IPv6 can break some of the components in Windows, so you need to set IPv4 as the preferred network protocol on Windows. Changing the settings from Registry is easier because it requires less number of steps.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">A. <strong>Steps to change network protocol preference from IPv6 to IPv4<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Log into the Windows user account as an <strong>admin<\/strong>.<\/li>\n\n\n\n<li>Press <strong>Windows + R<\/strong>.<\/li>\n\n\n\n<li>Input <strong>Regedit <\/strong>and hit <strong>enter<\/strong>.<\/li>\n\n\n\n<li>From the left pane, navigate to <strong>HKLM\\SYSTEM\\CurrentControlSet\\Services\\Tcpip6\\Parameters<\/strong>.<\/li>\n\n\n\n<li>Create a <strong>New Key <\/strong>in this location.<\/li>\n\n\n\n<li>Input the <strong>following information<\/strong>:\n<ul class=\"wp-block-list\">\n<li>Key: DisabledComponents<\/li>\n\n\n\n<li>Type: REG_DWORD<\/li>\n\n\n\n<li>Value: 0x20<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">You\u2019ve successfully disabled IPv6 in Windows, so Sage 50 will now rely on the IPv4 connection protocol to connect to the company file stored on the server. Alternatively, you can use another company file to search for the data path and program path in Sage 50.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">B. Steps to find program and data paths from Sage 50:<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Open <strong>Sage 50 <\/strong>and choose a <strong>Local Company File<\/strong>.<\/li>\n\n\n\n<li>Go to <strong>File<\/strong>, then click on <strong>Open Company<\/strong>.<\/li>\n\n\n\n<li>View the <strong>window in full screen <\/strong>and note down the directory.<\/li>\n\n\n\n<li>Go to the <strong>Desktop <\/strong>screen.<\/li>\n\n\n\n<li>In the <strong>Start <\/strong>menu, type in <strong>Sage 50<\/strong>.<\/li>\n\n\n\n<li><strong>Right-click <\/strong>on the sage 50 icons.<\/li>\n\n\n\n<li>Choose <strong>Properties <\/strong>and note down the directory.<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code><strong>Note<\/strong>: Compare both the data path and program path. If they differ, move the data file to the correct location and then try to launch Sage 50. You can also move the program path, but that is a very long process.<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"conclusion\"><\/span>Conclusion<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">I hope that you were able to fix the Sage 50 error connecting to the database by following the solutions in this post. I\u2019ve offered a detailed, step-by-step walkthrough of both troubleshooting and fixing this error. However, most of these solutions require you to have admin rights in Windows, so contact your system administrator if you don\u2019t have an administrator account.<\/p>\n\n\n\n<h2 class=\"wp-block-heading has-text-align-center\"><span class=\"ez-toc-section\" id=\"faq\"><\/span>FAQ<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n<div class=\"wp-block-ub-content-toggle wp-block-ub-content-toggle-block\" id=\"ub-content-toggle-block-3b38cdbb-a9f1-4a06-a20f-4fa6cdc55e2c\" data-mobilecollapse=\"false\" data-desktopcollapse=\"true\" data-preventcollapse=\"false\" data-showonlyone=\"true\">\n<div class=\"wp-block-ub-content-toggle-accordion\" style=\"border-color: #f1f1f1; \" id=\"ub-content-toggle-panel-block-\">\n\t\t\t<div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" style=\"background-color: #f1f1f1;\" aria-controls=\"ub-content-toggle-panel-0-3b38cdbb-a9f1-4a06-a20f-4fa6cdc55e2c\" tabindex=\"0\">\n\t\t\t<h4 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-3b38cdbb-a9f1-4a06-a20f-4fa6cdc55e2c\" style=\"color: #000000; \">What to do if the Actian service stops on the server?<\/h4>\n\t\t\t<div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\" style=\"color: #000000;\"><span class=\"wp-block-ub-content-toggle-accordion-state-indicator wp-block-ub-chevron-down open\"><\/span><\/div>\n\t\t<\/div>\n\t\t\t<div role=\"region\" aria-expanded=\"true\" class=\"wp-block-ub-content-toggle-accordion-content-wrap\" id=\"ub-content-toggle-panel-0-3b38cdbb-a9f1-4a06-a20f-4fa6cdc55e2c\">\n\n<p class=\"wp-block-paragraph\">When Actian stops working, Sage 50 cannot connect to the database, so it throws an error. You can open the task manager and restart the Actian service to fix this problem. You may have to reinstall Actian if its files are damaged.<\/p>\n\n<\/div>\n\t\t<\/div>\n\n<div class=\"wp-block-ub-content-toggle-accordion\" style=\"border-color: #f1f1f1; \" id=\"ub-content-toggle-panel-block-\">\n\t\t\t<div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" style=\"background-color: #f1f1f1;\" aria-controls=\"ub-content-toggle-panel-1-3b38cdbb-a9f1-4a06-a20f-4fa6cdc55e2c\" tabindex=\"0\">\n\t\t\t<h4 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-3b38cdbb-a9f1-4a06-a20f-4fa6cdc55e2c\" style=\"color: #000000; \">Does creating custom firewall rules for Sage 50 create security risks?<\/h4>\n\t\t\t<div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\" style=\"color: #000000;\"><span class=\"wp-block-ub-content-toggle-accordion-state-indicator wp-block-ub-chevron-down\"><\/span><\/div>\n\t\t<\/div>\n\t\t\t<div role=\"region\" aria-expanded=\"false\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" id=\"ub-content-toggle-panel-1-3b38cdbb-a9f1-4a06-a20f-4fa6cdc55e2c\">\n\n<p class=\"wp-block-paragraph\">No, it doesn\u2019t. The rule specifically applies to Sage 50, so no other program can use the same rule. Further, you add custom ports to unblock in Firewall, and these ports are exclusively used by Sage 50.<\/p>\n\n<\/div>\n\t\t<\/div>\n\n<div class=\"wp-block-ub-content-toggle-accordion\" style=\"border-color: #f1f1f1; \" id=\"ub-content-toggle-panel-block-\">\n\t\t\t<div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" style=\"background-color: #f1f1f1;\" aria-controls=\"ub-content-toggle-panel-2-3b38cdbb-a9f1-4a06-a20f-4fa6cdc55e2c\" tabindex=\"0\">\n\t\t\t<h4 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-3b38cdbb-a9f1-4a06-a20f-4fa6cdc55e2c\" style=\"color: #000000; \">What should I do if I have different versions of Sage 50 on servers and workstations?<\/h4>\n\t\t\t<div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\" style=\"color: #000000;\"><span class=\"wp-block-ub-content-toggle-accordion-state-indicator wp-block-ub-chevron-down\"><\/span><\/div>\n\t\t<\/div>\n\t\t\t<div role=\"region\" aria-expanded=\"false\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" id=\"ub-content-toggle-panel-2-3b38cdbb-a9f1-4a06-a20f-4fa6cdc55e2c\">\n\n<p class=\"wp-block-paragraph\">You should upgrade Sage 50 on your workstations, because, after you\u2019ve upgraded the software on the server, the company file and connection manager are also upgraded. Previous versions of Sage 50 will not be able to access the data in the upgraded company file.<\/p>\n\n<\/div>\n\t\t<\/div>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sage 50 cannot connect to its database because of underlying errors. If the Actian service isn\u2019t running in the first place, then Sage 50 won\u2019t be able to communicate with the data file, leading to the error. Further, various security programs such as Windows Firewall can cause this error. In rare cases, incorrect data path&hellip;&nbsp;<a href=\"https:\/\/www.bigxperts.com\/sage\/sage-50-error-connecting-to-database\/\" class=\"\" rel=\"bookmark\">Read More &raquo;<span class=\"screen-reader-text\">Fix Sage 50 Error Connecting to Database<\/span><\/a><\/p>\n","protected":false},"author":7,"featured_media":85366,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","footnotes":""},"categories":[7],"tags":[],"class_list":["post-4361","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sage-errors"],"featured_image_src":"https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2022\/06\/How-to-Fix-Sage-50-Error-Connecting-To-Database.jpg","author_info":{"display_name":"Rick","author_link":"https:\/\/www.bigxperts.com\/sage\/author\/robert\/"},"uagb_featured_image_src":{"full":["https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2022\/06\/How-to-Fix-Sage-50-Error-Connecting-To-Database.jpg",840,300,false],"thumbnail":["https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2022\/06\/How-to-Fix-Sage-50-Error-Connecting-To-Database-150x150.jpg",150,150,true],"medium":["https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2022\/06\/How-to-Fix-Sage-50-Error-Connecting-To-Database-300x107.jpg",300,107,true],"medium_large":["https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2022\/06\/How-to-Fix-Sage-50-Error-Connecting-To-Database-768x274.jpg",768,274,true],"large":["https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2022\/06\/How-to-Fix-Sage-50-Error-Connecting-To-Database.jpg",840,300,false],"1536x1536":["https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2022\/06\/How-to-Fix-Sage-50-Error-Connecting-To-Database.jpg",840,300,false],"2048x2048":["https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2022\/06\/How-to-Fix-Sage-50-Error-Connecting-To-Database.jpg",840,300,false],"neve-blog":["https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2022\/06\/How-to-Fix-Sage-50-Error-Connecting-To-Database.jpg",840,300,false],"web-stories-poster-portrait":["https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2022\/06\/How-to-Fix-Sage-50-Error-Connecting-To-Database-640x300.jpg",640,300,true],"web-stories-publisher-logo":["https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2022\/06\/How-to-Fix-Sage-50-Error-Connecting-To-Database-96x96.jpg",96,96,true],"web-stories-thumbnail":["https:\/\/www.bigxperts.com\/sage\/wp-content\/uploads\/2022\/06\/How-to-Fix-Sage-50-Error-Connecting-To-Database-150x54.jpg",150,54,true]},"uagb_author_info":{"display_name":"Rick","author_link":"https:\/\/www.bigxperts.com\/sage\/author\/robert\/"},"uagb_comment_info":0,"uagb_excerpt":"Sage 50 cannot connect to its database because of underlying errors. If the Actian service isn\u2019t running in the first place, then Sage 50 won\u2019t be able to communicate with the data file, leading to the error. Further, various security programs such as Windows Firewall can cause this error. In rare cases, incorrect data path&hellip;&nbsp;Read&hellip;","_links":{"self":[{"href":"https:\/\/www.bigxperts.com\/sage\/wp-json\/wp\/v2\/posts\/4361","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bigxperts.com\/sage\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bigxperts.com\/sage\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bigxperts.com\/sage\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bigxperts.com\/sage\/wp-json\/wp\/v2\/comments?post=4361"}],"version-history":[{"count":2,"href":"https:\/\/www.bigxperts.com\/sage\/wp-json\/wp\/v2\/posts\/4361\/revisions"}],"predecessor-version":[{"id":86660,"href":"https:\/\/www.bigxperts.com\/sage\/wp-json\/wp\/v2\/posts\/4361\/revisions\/86660"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.bigxperts.com\/sage\/wp-json\/wp\/v2\/media\/85366"}],"wp:attachment":[{"href":"https:\/\/www.bigxperts.com\/sage\/wp-json\/wp\/v2\/media?parent=4361"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bigxperts.com\/sage\/wp-json\/wp\/v2\/categories?post=4361"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bigxperts.com\/sage\/wp-json\/wp\/v2\/tags?post=4361"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}