Sage 50 Connection Manager Error

Sage 50 Connection Manager Error, Issues and Problems

—

by

Lawrence Flanagan
in

Oftentimes people complain about an issue within their accounting program where they report a Sage 50 connection manager error. The error within their Windows operating system often reads. The Sage 50 Connection Manager helps to control requests from Sage 50 Accounting and third-party software to connect to your company’s data.

Sage 50 connection manager isn’t running on this computer where you store your data

or

The connection manager could not start the database engine

You see another issue going on when using Sage Simply Accounting 2012, which reads.

The Sage Simply Accounting Connection Manager is installed but it isn't running on the computer where you store your data.

Causes of Sage 50 Connection Manager Error

There are several reasons why this error may appear on your computer screen.

  • Sage 50 Connection Manager service is not running on the same computer that holds the company data.
  • Connection manager settings would be disabled if it is local data.
  • In case the data is not local, instead, it is located on the server
  • The connection manager is not installed locally either and it too is running on the server.
  • If the computer that contains the data is being upgraded. If this is something that is bugging you, you then get help at Sage 50 Update.
  • Windows is not updated to its latest version.
  • In case the data is located on the local folders, i.e. My Folder, the file sharing, and security settings might be compromised.
  • Program installation was not through even after indicating that it was.
  • Once upgraded to Windows 10, either the service has been disabled or it fails to start back on its own.

Tips to Fix Sage 50 Connection Manager Error

Here are the steps to fix the Sage 50 connection manager error.

Method I: Starting the Connection Manager service by using the Control Panel

  • Go to Windows Control Panel.
  • Go to View by and change it either to the Large Icons or Small Icons on the top right corner of the open window.
  • Opt for Administrative Tools.
  • Now choose Services.
  • Browse Sage 50 Connection Manager, and verify by clicking on it if the Startup Type column has been disabled, whether Automatic or Automatic (Delayed Start).
  • In case you find it disabled: Go to Sage 50 database Connection Manager, right-click on it, and opt for Properties.
  • Go to the General tab and switch the Startup Type to either Automatic or Automatic (Delayed Start).
  • Hit Apply and hit Start to make the service active.
  • Finally, try opening the database.

Method II: If the Data File is Located in My Documents

  • Go to the root of the C: drive and create a new folder there.
  • Now copy and paste the data file (.SAI file and .SAJ folder) to this new folder for all of the companies.
  • In case the file is being used by multiple users across the workstations, get the new folder set to a new shared network.
  • Launch the data file from the new folder.

Tips to Fix Sage 50 Connection Manager Service is Not Running on the Computer Where Data is Located

There are three methods to fix the Sage 50 connection manager service is not running on the computer where data is located’ error message. Here are the three methods.

Method I: To start the Connection Manager Service in Windows Services

  • First, the user is required to go to the ‘Control Panel’ on their workstation.
  • The user is required to go to the section with the title ‘View by, and in the ‘View by’ section, the user needs to change it either to the Large Icons or Small Icons on the top right corner of the open window.
  • Now, the user is required to click on the ‘Administrative Tools’ option, followed by choosing the option titled ‘Services’.
  • Required to look for the ‘Sage 50 Connection Manager’, and verify by clicking on it if the Startup Type column has been disabled, or whether it has been set to either Automatic or Automatic (Delayed Start).
  • If the connection manager is disabled,
    • Then the user needs to go to the Sage 50 Database Connection Manager, right-click on it once found
    • And then select ‘Properties’ from the menu that opens up when the user performs the right-click.
    • In the ‘General’ section of the ‘Properties’ menu item, the user needs to switch the Startup Type to either Automatic or Automatic (Delayed Start).
    • Now, the user needs to press the ‘Apply’ button to implement the changes.
  • The next step that the user needs to do is that the user needs to close the Sage 50 application if it is open, and they should try opening the database.
  • Furthermore, the user is also required to go to the task manager on their workstation and go to the tab with the title ‘Show Processes From All Users.
  • The user needs to look for all Sage 50-related processes and terminate them.
  • Now, the user needs to go to the ‘Services’ tab.
  • Needs to look for the ‘Sage 50 Database Connection Manager’ and right-click on and hit ‘Start’. The status of the service will change to Started.
  • Now, the user needs to reopen the Sage 50 application and reopen their company file to see if it is working.

Method II: Checking if the C:\Program file exists

  • First, the user needs to go to the C:\ drive on their workstation’s ‘File Explorer application.
  • If there is a file called ‘Program’ with no extension in front of it, then it would mean that the file size is very small. If such is the case, then the user will be required to assign a different name to the file and set it to ‘Program1’.
  • Finally, the user needs to try to start the Sage 50 Connection Manager service again.

Method III: To start the Sage 50 Connection Manager using the icon in the System tray

  • First, the user is required to double-click on the Sage 50 Connection Manager application, which can be found in the System Tray, which is next to the wifi symbol at the bottom.
  • Alternatively, the user can follow the following data path to find the Simply.SystemTrayIcon.exe file: C:\Program Files (x86)\winsim\ConnectionManager
  • Once the user has navigated to the data path mentioned above and found the file, the user needs to double-click on it. It will open up the file, and the user will be able to see the following:
    • If the user sees “Running: No”, then the user will have to select the ‘Start Service’ option.
    • If the user sees “Running: Yes”, then the user will have to select the ‘Stop Service’ option, followed by selecting the ‘Start Service’ option.

Steps to Fix the Sage 50 Canada Connection Manager Issue by Checking the Data File

  • First, the user needs to navigate to the root of the C: drive on their workstation and they need to create a new folder in the root of the C: drive.
  • Then need to paste all the data files for all the companies in the folder the user created in the previous step.
  • If the file is being used by more than one user on a different workstation or different workstation, then the user is required to get the new folder set up on a new shared network for shared access.
  • Finally, the user can try running the file from the new folder.

Tips to Solve the Sage 50 Network Error with Connection Manager

Oftentimes when you try to access Sage on the second computer on your server you get an error. The error message may read something like “A network error occurred while communicating with the connection manager“. If you receive the same error on your standalone workstation, then that also signals the problem.

Reasons for Sage 50 Network Error

Several factors cause communication errors on your Sage 50 and server.

  • The Shared folder has been broken.
  • Workstations are working on different servers.
  • You are using Windows: Windows 7, XP, VISTA, Server 2008 on which Sage 50 2018 doesn’t work.
  • Connection Manager is not turned on the server.

Steps to Fix the Sage 50 Network Error Occurred While Communicating with the Connection Manager

Learn how to fix the Sage 50 Canada network error that occurred while communicating with the connection manager”. Follow the given simple steps to fix it.

Step 1: Use the Primary system’s IP Address to open the company file

  • Go to the Sage 50 icon on your computer screen.
  • Log in and select Open An Existing Company.
  • Go to the File Name and type: \ The IP Address of the computer where the data is stored
  • Go to the Data File (one with the extension .SAI)
  • Try to open the Company File now.

Step 2: When you have two Routers

  • Unplug your internal router’s router cable.
  • Turn off the internal router for at least one minute. (Remove the cable from the plug)
  • Start the router. (Plug the cable back)
  • Go to the data and try to access it.
  • If you can access the data, then it means:
    • The IP address ranges of both the internal router and internal service provider are conflicting.
    • The router of the internal service provider is blocking the packets by its firewall.

Step 3: The Data is Placed in a Virtual Machine Server on top

  • Ensure that you have installed the Connection Manager on the same server where data is placed.
  • If you find out that your data is on the virtual machine server but not on the actual server, then you are required to install Sage Connection Manager on the same virtual server.

Step 4: If your company file resides on a standalone computer

  • Ensure that the Sage Connection Manager is in working condition.
  • Ensure that you can open a sample company.
  • Copy and paste the files to the desktop.
  • Try to open the company file from the new location.

Step 5: Rebooting Your Server

  • If the computers were turned off because of some accidental error, some of the workstations would still be able to access the company file.
  • Reboot your computer, and reboot the server.
  • Check if you can open the file from the workstation.

Step 6: Installing the full version on the server

  • Download and install the Sage 50 full version on the server.
  • Check if the data or sample can work locally.

Tips to Resolve Sage 50 Connection Manager Could Not Start the Database Engine

Follow the below steps to fix the Sage 50 connection manager could not start the database engine because the database engine reported an error.

Restart the Sage 50 Connection Manager

  • Start by selecting Control Panel, then click on Administrative Tools, and then click Services.
  • Click the Sage 50 Database Connection Manager menu option and then select Stop.
  • After that, you have to right-click the Sage 50 Database Connection Manager menu option.
  • Click the Start option.
  • If you receive a message Stopping the Connection Manager was not possible. Administrator rights are required.
  • Now you can try to open the company file.

Reinstall the program

  • Start by uninstalling Sage 50
    • On the Windows Start, Apps, and Features you have to right-click
    • Then you have to find the Sage 50 version that you are trying to repair and then you have to click Uninstall.
    • To complete the uninstall you have to follow the wizard.
  • Then Reinstall Sage 50
  • Recheck that the company file will now open

Move the files out of a cloud-synchronized folder

  • To identify whether your data is stored in a cloud folder
  • If the files are in a cloud-synchronized folder, move them to a different, non-synchronized folder.
    • The C: Drive is the ideal location for your data folders.

Verify that mysqld.exe and mysqld-nt.exe exists

  • Check that the file mysqld-nt.exe is present in the following location: C:\Program Files (x86)winsimConnectionManagerMySqlBinary5.0.38. mysql
  • Check that the file mysqld.exe is present in the following location: C:\Program Files (x86)winsimConnectionManagerMySqlBinary5.6.10.
  • mysql
  • In case they don’t exist, your firewall or antivirus program may have quarantined the executable file or it may have been manually deleted.
  • You can get in touch with the security software supplier if the file was quarantined to learn how to restore or whitelist this executable.
  • Repair Sage 50 if the file was removed manually.

Reinstall the Connection Manager

  • Run as Administrator by right-clicking the Command Prompt and choosing it from the Windows Start menu.
  • Then you have to type Sage 50 Database Connection Manager as sc delete.
    • On the command line, you have to enter “sc query type= service state= all” followed by “sc remove “Sage 50 Database Connection Manager” if you encounter the error “[SC] OpenService FAILED 1060:”
  • When you press F5 to refresh your Services list, you will see that the service is no longer available.
  • Open task manager (CTRL+SHIFT+ESC) after confirming the service has been destroyed. Click or check the process tab. Show all users’ processes then
  • Simply.SystemTrayIcon.exe should be ended.
  • Then you have to go to the correct winsim folder:
    • 32-bit computers go to: C:\Program Files\winsim
    • 64-bit computers go to: C:\ Program Files (x860\winsim
    • Then delete the folder of Connection Manager
  • Repair the Sage 50 installation

Start the Windows Event Log service

  • Begin by selecting Control Panel, and Administrative Tools, and then you have to select Services.
  • In the services list you have to select Windows Event Log and then open the Properties window
  • Change the Startup Type to Automatic if the service is Disabled.
  • Then you have to select Apply and then the Start button will be available.
  • To start the service you have to select the Start button if the service is available/automatic, then you have to select OK.
  • Open Sage 50 if the service starts.
  • In case the service is not starting or there is an error 1053, then you have to select the Log On tab, then you have to Add the local administrator.
  • After that, confirm the service status is started.
  • Then you should try to open the company file.
    • Open Command Prompt as administrator if you encounter error 4201, the instance name given was not recognized as acceptable by a WMI data provider.
    • Enter the command cd C:\Windows\System32\LogFile\sWMI.
    • Rename RtBackup to RtBackup2 by typing. Go to the next step if you receive an access denied error notice; otherwise, you have to go to step 12.
  • The Command Prompt option can be found under Start. Run as Administrator is the right-click menu option. If an administrator password or confirmation is requested, you can type it in or give the requested information.
  • Enter the following commands one at a time to have them run one after the other. (Remember to take care of the gap between the command and its parameter.)
    • takeown /f C:\windows\system32\logfiles\wmi\rtbackup cacls C:\windows\system32\logfiles\wmi\rtbackup /G administrators:F
  • Then you have to exit Command Prompt and reboot the computer.
  • Kindly contact your local IT person to fix this issue, if the event log is still not starting.

Open Existing Company

  • You have to click Select an existing company if the recently used company has a UNC path (for example,\\server\company name)
  • In Windows Explorer, you have to browse to the company (for example C:\Sage 50 Data\)

Verify if the SAJ folder has a read-only attribute

  • You have to Close Sage 50.
  • Then you have to browse to the location where the company file is located.
  • With the extension SAJ you have to right-click the folder.
  • Then you have to select Properties.
  • If a checkmark is there you have to clear the Read-Only box and then click on OK.
  • Lastly, you have to restart Sage 50 Accounting and then again try to open the company file.

Verify all files and folders are visible in the .SAJ folder

  • Firstly, go to the location where the company file is located.
  • Then you have to right-click the SAJ folder and click on Properties.
  • After that, you have to clear the Hidden box checkmark if one is there and then select Apply.
  • Select OK and then open the SAJ folder.
  • Within the .SAJ folder verifies that all files and folders are located.

Replace the ODBC 3.51.28 with 3.51.19

  • You have to place the data that is required to be opened or converted on the C:\\Drive

Only 1 workstation is having a problem

  • To the data map a network
  • Make sure that you can open the company

On the server save the data files in another folder

  • On the server make a copy of the .SAI file and the .SAJ folder in a different folder
  • Ensure that you can open the company

My data is on Remote Data Access

  • Re-download a copy of the company file from Remote Data Access that is causing an error.
    • Begin by choosing the location and file name that you want and then click Save.
    • When asked if you want to overwrite the existing file that contains the error, choose the same name and directory that the file was saved in and then click Yes.
    • The company file should open properly after it has finished downloading and syncing.

Restore from backup

  • Find a backup .CAB file
  • Restore the backup

Tips to Solve the Sage 50 Cannot Find the Connection Manager Issue

The Sage 50 Connection Manager helps in managing requests for connections to your company’s file from Sage 50 Accounting and other software.

Error messages, problems, and codes related when you perform a task on Sage 50 related to Sage Connection Manager.

  • When opening the company file, Sage 50 reports that it cannot find the Connection Manager.
  • When Windows first started, Sage 50 Database Connection Manager did not start.
  • I just installed a Windows 10 upgrade.
  • Every time I start Sage 50 Database Connection Manager, do I have to stop the DHCP Client first manually?

Here you will read the steps properly that is why you get the error of Sage 50 cannot find the Connection Manager when you are opening the company file.

  • Service times out.
  • When Sage 50 Database Connection Manager is not working.
  • Exceptions and ports are not added.

Steps to Fix the Sage 50 Cannot Find the Connection Manager

Method 1: Start and Stop Service Connection Manager

  • On your taskbar, you have to click on the Sage 50 Connection Manager icon that is on the bottom right side beside the clock.
Note: If the connection manager icon is not visible follow the steps Click the Windows Start button >> All Programs >> Sage >> your Sage 50 version, Sage 50 Connection Manager
  • Then you have to click on the Start Service in case the service is stopped.
  • Click Start Service once the service has ended (Status Running indicates No) if it is already running (Status Running indicates Yes).
  • After that, you have to wait until the Status Running displays Yes. 
  • Then you have to click OK and then again you have to open the company file.

Method 2: Disabled to Automatic Connection Manager

  • Start by browsing the Windows Control Panel.
  • Then you have to open Administrative Tools and then you have to double-click the Services.
  • After that, you have to find and double-click Sage 50 Database Connection Manager.
  • You have to click Start, to start the service.
    • Or you have to click Stop which is followed by Start.
    • In case both Start and Stop buttons are greyed out, then you have to change the startup from Disabled to Automatic, then you can try to start it.
  • At last, you have to click OK.

Method 3: IP Configuration

  • You have to get the IP address of the server.
  • Then you have to click on the Start button, then on the Search Box, you have to type cmd and then click on Enter.
  • You will see a DOS window on the screen.
  • Then you have to type ipconfig and then click on Enter.
  • After that, you have to take note of the IPaddress – IPv4 Address.
  • Open Sage 50 on the local workstation and then choose to Select an existing company.
  • Enter the server’s \\IP address in the File name field of the Sage 50 – Open Company Window and click Open.
    • Example: \\192.143.20.8
  • Then you have to browse to the server-shared folder.
  • Try to open the data file again.

Method 4: Registry Editor

  • First, you have to click Start, then you have to click Run, type regedit, and then you have to click OK. 
  • By choosing File-Export and selecting All in the Export Range, you can create a registry backup.
  • Find the following registry subkey and then click it:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control

  • Then you have to right-click Control and then select New.
  • Now you have to choose DWORD Value.
  • Type ServicesPipeTimeout and then click ENTER in the New Value #1 box.
  • Right-click ServicesPipeTimeout, and then select Modify.
  • Enter the number of milliseconds you wish to wait until the service times out by clicking Decimal.
  • You have to click OK.
    • A data value of 35,000 is usually sufficient to keep service timing out.
    • To meet your specific startup needs, you can, however, reduce or increase this value.
    • Type 60000, for example, to wait 60 seconds before the service expires.
  • Lastly, you have to close Registry Editor, and then you have to restart the computer.

Method 5: DHCP Client

  • First, you have to select Administrative Tools and Services from the Control Panel.
  • Then you have to stop DHCP Client.
  • Now you have to start Sage 50 Database Connection Manager.
  • If there isn’t an error message then you have to start the DHCP client and follow the steps below to have the Connection Manager launch when Windows starts.
  • Simplyconnection-DHCP.bat can be downloaded from the attachment. Then save it to the STARTUP Folder for All Users.
  • For all users to access the STARTUP folder:
  • Right-click the Start Button.
  • Press the Open All Users button.
  • Then select the STARTUP folder by clicking on Programs, followed by.
  • The simplyconnection-DHCP.bat file contains the following information mentioned below…
    • @ECHO OFF
    • ECHO ————————————–
    • ECHO -SIMPLY ACCOUNTING CONNECTION MANAGER-
    • ECHO ————————————–
    • ECHO.
    • ECHO Stopping DHCP Client. Please Wait….
    • NET STOP “DHCP Client”
    • ECHO STOPPED
    • ECHO.
    • ECHO Starting Simply Accounting Connection Manager. Please Wait….
    • NET START “Simply Accounting Database Connection Manager”
    • ECHO STARTED
    • ECHO.
    • NET START “DHCP Client”
    • ECHO STARTED
    • EXIT
  • You can copy the content put it into Notepad, and then save it as simply connection-DHCP.bat and place it in the startup folder for all users.
  • Change the startup type of Sage 50 Connection Manager from automatic to manual under Services in the control panel.

Method 6: Use Static IP Address

  • Start by clicking on Start and then select Run.
  • Type cmd in the Run Command dialogue box.
  • Then you have to click OK (The DOS Prompt will open).
  • Now you have to type ipconfig/all in the DOS Prompt and then you have to press Enter.
  • After that, you have to make note of all the settings.
  • Now you have to open the Control Panel.
  • You have to select Network Connections now.
  • Then you have to right-click on Local Area Connection (The Ethernet Adapter displayed in the DOS command prompt).
  • Then you have to click on Properties.
  • After that, you have to highlight Internet Protocol (TCP/IP)
  • After this, you have to click on Properties.
  • If you would like to enter additional information, such as WINS information, click on Advanced and fill out the appropriate areas with the previously mentioned information.
  • Now you can start Connection Manager.

Tips to Fix the Sage 50 Canada Connection Manager Issues

There are two methods to fix the Sage 50 Canada Connection Manager issue. The first method is starting the connection manager service by using the Control Panel.

Steps to Fix the Sage 50 Canada Connection Manager issue by using the Control Panel

  • First, the user is required to go to the ‘Control Panel’ on their workstation.
  • Required to go to the section with the title ‘View by, and in the ‘View by’ section, the user needs to change it either to the Large Icons or Small Icons on the top right corner of the open window.
  • Now, the user is required to click on the ‘Administrative Tools’ option, followed by choosing the option titled ‘Services’.
  • Required to look for the ‘Sage 50 Connection Manager’, and verify by clicking on it if the Startup Type column has been disabled, or whether it has been set to either Automatic or Automatic (Delayed Start).
  • If disabled, then the user needs to go to the Sage 50 Database Connection Manager, right-click on it once found, and then select ‘Properties’ from the menu that opens up when the user performs the right-click.
  • In the ‘General’ section of the ‘Properties’ menu item, the user needs to switch the Startup Type to either Automatic or Automatic (Delayed Start).
  • Now, the user needs to press the ‘Apply’ button to implement the changes.
  • The next step is to close the Sage 50 application if it is open, and they should try opening the database.
  • Furthermore, the user is also required to go to the task manager on their workstation and go to the tab with the title ‘Show Processes From All Users.
  • The user needs to look for all Sage 50-related processes and terminate them.
  • Now, the user needs to go to the ‘Services’ tab.
  • Needs to look for the ‘Sage 50 Database Connection Manager’ and right-click on and hit ‘Start’. The status of the service will change to Started.
  • Now, the user needs to reopen the Sage 50 application and reopen their company file to see if it is working.

As mentioned above, there are two methods to fix the Sage 50 Canada connection manager issue. The second method is doing so by checking if the data file is located in my documents. Following are the steps that the users can follow so that they can fix the Sage 50 Canada Connection Manager Issue by checking if the data file is located in my documents.

Get in touch with our Sage 50 Technical Consultant Team. If you face any Sage 50 issues while going through the process. Get yourself connected with our Sage 50 Consultant. For instant redressal of your problem our 24/7 helpline now.

Phone

+1-347-967-4078