How to Download and Install Sage 50 Connection Manager?
What is Sage 50 Connection Manager?
The Sage 50 Accounting utilizes the Connection Manager to manage access to its MySQL database. But what is Sage 50 Connection Manager? Sage 50 is a real-time Connection Manager updates and application where the data changes in real-time. It does not require saving any changes manually. The Sage 50 Accounting Connection Manager can control the requests from third-party software and Sage 50 Accounting that can connect to the company’s data of the user. The Connection Manager needs to be installed within the computer or server where the company data has been stored. When it comes to a multi-user environment, such as. Premium and Quantum editions only, it is also used to allow a secondary user access to the database to enable changes in real-time to the main data file location.
User Navigation
How to Download and Install Sage 50 Connection Manager?
To download and install, follow the below steps:
- Sage 50 Connection Manager is automatically installed once the Sage 50 is installed.
- When you are trying to install Sage 50, be sure to review the options to know if the system will be a server or a workstation.
- A Typical option is applied on a workstation, and the full accounting product suite including the Sage 50 Connection Manager is installed.
- You need to apply the Advanced option on a Server, but only the Connection Manager portion will be installed.
Where to Install Sage 50 Connection Manager?
- The Connection Manager is installed within every system where Sage 50 is installed.
- It can only be installed within a Windows OS environment and not on Mac OS, Linux system, or NAS drive.
- It should be installed within the computer or server where the data has been stored.
How to Install or Update Sage 50 Connection Manager on the Server?
Follow the steps below to install or update:
Install the Connection Manager
- First you need to log in to the server.
- Next, download the program and run the .exe file.
- Now, select Yes for the Windows Firewall setup
- Select Next.
- Click Select Advanced installation type.
- Click Select Next to proceed.
- Finally, click select Server – only for Sage 50 Server Components and select Finish.
To Update the Connection Manager
- Navigate to the Windows Start menu.
- Next, type Sage 50 Connection Manager.
- Now select the App.
- Finally, click the Update button.
NOTE: The Update option will only be displayed once you select a Server-only install.
How to Know If the Sage 50 Connection Manager is Installed or Not?
Locate the Connection Manager system tray icon in the notifications bar in Windows 8 and 10, see below.
- Next, click the icon to open the status window.
- The other available option to open the Connection Manager is to
- Go to the Sage 50 Accounting 202x program group.
- Now click the Start menu and select the Sage 50 Accounting Connection Manager
- Go to Sage 50 Accounting and select Setup > Connection Manager.
Which Version of the Sage 50 Connection Manager Should Be Chosen to be Installed?
- The current version of the software should be installed within the server first before the workstations.
Sage 50 Connection Manager is installed But It Isn’t Running Error
- The Connection Manager service has been disabled within the Windows services settings
- Certain installations within the network are not updated
- Security settings are blocking certain Sage applications
- Some, pending Windows updates
Option 1: Verification if the Connection Manager version within the server and workstation is the same
Option 2: Start the Sage 50 Connection Manager
- Start by clicking the Windows Start button
- Next type Sage 50 Connection Manager.
- Now, double-click the Sage 50 Connection Manager app.
- When you have your data on a server, follow the same steps on your server.
- When the status shows “Running: No“, select Start Service
- When the status shows “Running: Yes“, select Stop Service, then Start Service
- If the option for stopping or starting the service is missing, you need to make an installation repair or reinstall Sage 50.
Option 3: Begin with starting the Connection Manager Service in Windows Services
- Start by clicking on the Windows Start option and type Services.
- Next, double-click the Services app.
- Now, scroll down to the Services list and click Sage 50 Database Connection Manager.
- Check the Startup Type column status.
- When the status is Disabled:
- Right-click on Sage 50 Database Connection Manager.
- Now select Properties.
- Within the General tab, change the Startup type to Automatic or Automatic (Delayed Start).
- Click Apply.
- Click Start to start the service.
- When the status is Automatic or Automatic (Delayed Start) but the Service is “Starting” (as opposed to Started):
- Close Sage 50
- Now, access the Task Manager (CTRL+SHIFT+ESC) and click the Processes tab
- Next, click the Show Processes from all users button
- Now, end all the processes related to Sage 50, especially the Sage 50 Database Connection Manager.
Option 4: Disable the antivirus and security programs temporarily
Option 5: Restart the computer
- Begin by restarting the system or server where the data is stored.
- Next, check for any pending updates and install them at the same time.
- Finally, reopen the data file.
How to Restart Sage 50 Connection Manager?
There are times when you encounter errors that require you to stop and restart the Connection Manager for Sage 50 Accounting. One can easily locate the Connection Manager using the Windows search.
Solution:
- Go to the Start menu.
- Next, type Sage 50 Connection Manager
- Now, select the App.
- Within the Sage 50 Connection Manager window, go to the Connection Manager section.
- Click Stop Service, then OK.
- Click Start Service, then OK.
- Finally, open Sage 50.
How to do a Basic or Advanced Uninstall of Sage 50 Accounting?
Sometimes you need to uninstall Sage 50 Accounting to remove the previous versions. This can also help resolve subscription problems that are caused by errors, expired trial versions, or red Xs on icons during the modification of a subscription.
Solution for Basic Uninstall
Follow the steps below:
- Start by backing up the Sage 50 data.
- Navigate to the Windows Start menu
- Next search for the Control Panel.
- Now, launch the Control Panel.
- Then, select Programs and Features.
- Find the Sage 50 Accounting Version and click Uninstall.
- Finally, restart the computer.
Top Tips for Resolving Sage 50 CA Connection Manager Issues
To resolve Sage 50 CA Connection Manager problems generally needs addressing the network, configuration, and service-related problems. Let us look at the top troubleshooting tips:
- Make sure that the Connection Manager is Running
The Sage 50 Connection Manager should be running within the system hosting the company file.
To verify:
- Check the Windows Taskbar for the Connection Manager icon, usually located within the system tray.
- Launch the Windows Services and confirm that the service is running.
- Here, locate the Sage 50 Database Connection Manager.
- Finally, restart the service if required.
- Verify the network Settings
Make sure that the host system, where the data file is located is accessible from other workstations:
- Make sure that the host computer has been turned on.
- Verify that the company file folder is shared and that the permissions allow read/write access for other users.
- Next, test network connectivity by pinging the host computer’s IP address or hostname.
- Check the Firewall and Antivirus
- Firewalls or antivirus software might block the Connection Manager.
Configure your security software to allow:
- Sage 50 Connection Manager through the firewall.
- Ports 13531, 13540, and 13541 for Sage 50 CA.
Next, add the Sage 50 installation folders to the exceptions/exclusions list of your antivirus software.
- Verify Database Path
The Connection Manager should know where the database file is located:
- Now, confirm the exact path to the Sage 50 company file.
- Make sure that all the workstations are pointing to the correct network location.
- Reinstall or Repair the Connection Manager
When the Connection Manager is corrupted:
- Start by uninstalling and reinstalling it from the Sage 50 installation media or the Sage website.
- Make sure you install the correct version of the Connection Manager for your Sage 50 version.
- Match Software Versions
- Make sure that all workstations and the server are utilizing the same version and update level of Sage 50 CA.
- Mismatched versions can avoid proper communication with the Connection Manager.
- Test with Administrator Rights
- Start by running Sage 50 as an administrator within the workstation to eliminate permission-related issues.
- Verify that the user account within the host computer has sufficient privileges to access the company file.
- Temporarily Disable UAC (User Account Control)
Go to Windows, UAC can interfere with network communication. Test the Connection Manager with UAC temporarily disabled:
- Go to Control Panel > User Accounts > Change User Account Control settings.
- Now, set the slider to Never Notify, then restart the system.
- Make sure of proper Network Configuration
For a multi-user setup:
- Utilize a wired connection instead of Wi-Fi for better stability.
- Assign a static IP address within the host computer to avoid any changes within its IP.
- Make sure that the Windows network is set to Private and not Public.
- Review Logs and Error Messages
Sage 50 Connection Manager usually provides error messages when something is wrong:
- Start by checking the Connection Manager log for detailed troubleshooting.
- Next, refer to Sage’s online support resources for guidance based on specific error codes.
- Consult Sage Support
When none of the above resolves the problem:
- Go to the Sage Knowledgebase.
- Next, contact Sage 50 technical support for advanced troubleshooting.
After following these steps systematically, one can resolve most Connection Manager problems within Sage 50 CA easily.
Conclusion!
So, there you have it friends, these are some of the facts, features, and aspects regarding the Sage 50 connection manager. Was this article helpful? Do share your feedback with us and we would love to hear from you.
Frequently Asked Questions:
Q1: What is the Sage 50 Connection Manager, and why is it necessary?
Ans: The Sage 50 Connection Manager is a service that helps handle the database for Sage 50 Canadian Edition. It allows multiple users to access the same company file simultaneously within a networked environment. The Connection Manager also makes sure that the data has been properly synchronized and secured during access. Without it, Sage 50 cannot open or access the database files.
Q2. How do I restart the Sage 50 Connection Manager if it stops working?
Ans: To restart the Connection Manager:
Within Windows:
Click Press Windows + R, and type services. msc, and press Enter.
Find Sage 50 Database Connection Manager within the list.
Now, right-click on it
Finally, select Restart.
Alternative Method:
Launch the Sage 50 Connection Manager application by searching for it in the Start menu.
Next, click on Start Service if it is not running.
Make sure that the Connection Manager restarts within both the host and client computers when using a networked setup.
Q3. Why is the workstation unable to connect to the company file on the server?
Ans: This problem can arise mainly due to:
Network Problems: The workstation is unable to communicate with the server hosting the company file. Make sure that the server is accessible and that the folder containing the file is shared with proper permissions.
Firewall or Antivirus Restrictions: Firewalls or antivirus software might be blocking the Connection Manager or the required ports. Add exceptions for the service and open ports 13531, 13540, and 13541.
Connection Manager Not Running on Server: Make sure that the Sage 50 Connection Manager service is running within the host computer.
Version Mismatch: Next, verify that all systems are running with the same version and update the level of Sage 50.
When these are not able to resolve the problem, ensure that the correct file path is being used within the workstation and check for any error messages for further troubleshooting.
