Configuring the program for a server environment
Note: This article is for a computer technician who is the administrator of your network
The following assumes the Sage 50 Connection Manager is installed and running on the server
Connection Manager Notes for technicians:
- The connection manager must BIND to the TCP protocol
- If there are any problems with locating TCP then a network error will generate
- IF there are any problems with the IP/Host name resolution then an error will generate or there will be delays opening and closing the data
- As a test open the data with an IP address of the server in the Open Company window
- DNS must be the same source for the workstations and server
- Multihoning is problematic for the connection manager
Section I: Shared folder settings and Sage 50 Database Connection Manager
- Right-click on your data folder, then select Sharing and Security from the drop down menu to test the rights of the users accessing the data
- Select the Share the folder radio button , then select Permissions
- Choose to share with EVERYONE and give full permissions to the folder
- Test accessing the data from the various workstations
- If the test is successful you may wish to remove the EVERYONE group from the Permissions tab for security reasons, and add each individual user in the Shared Permissions instead
- If the users are not available to add, proceed to step 2
- Use the Computer Server Management to add the LAN users
- Select Windows Start, Control Panel, Administrative Tools, then Computer Management
- Select Local Users and Groups Users and add the user here
- Once the user(s) has been added, go back to step 1 and add the individual user to the Shared Permissions on the data folder
- Try again to open the data across the network. If another connection error message is generated proceed to the next step
Section II: Add the local server adimistrator (not global admin) to users to the Log in for the Connection Manager Service
- Select Windows Start, Control Panel, Administrative Tools, then Services.
- Find the Sage 50 Database Connection Manager in the services list and double-click it to open the Properties window
- Select the Log On tab. Add the local administrator
- Confirm the service state is enabled at this stage, then select OK
- Open the Sage 50 Database Connection Manager properties window again
- Stop and then Start the Connection Manager service on the server
- If a 1069 error message is generated
- Try again to open up the database across the network
- Press the Windows Key + R.
- Type in secpol.msc.
- Scroll through the User Rights Assignments and double-click Log on a service.
- Add the network users to the log on list.
- Select OK.
- Restart the Connection Manager.Note: This is not the domain permissions but the local permissions for the server
- If there are two or more network cards installed on the server (multi-homing):
- Disable all but one (even if the network connection is virtual)
- Test the connection again.
- If connection is successful and the server enviroment needs more than one NIC then:
- Open the data with the IP address of the server rather than a UNC name
- Note: For example in the open company window using FILE NAME
- Add the server address to the HOSTS file.
- Sage 50 Accounting—Canadian Edition is neither tested nor designed for Virtual Network environment (AKA: Cloud computing)
- If the drive or folder which is shared is part of a Distributed File System, then Sage 50 Connection Manager will not recognize the folder. Recreate the folder outside of the Distributive folder.
- If the drive or folder is configured as a Web Service, then Sage 50 connection manager will not recognize the drive. Create the folder outside of the Web Service
- If the drive is an independent drive (is not configured in the computer’s BIOS), then Sage 50 connection manager will not recognize the drive
Source: Sage Community forums.
Disclaimer: Sage Accounting Solution is an independent provider of Sage Related services and is not affiliated with Sage.
See More: Support for this issue is available either by self-service or paid support options. Experts are available to resolve your Sage issue to ensure minimal downtime and continue running your business. First try to resolve the issue yourself by looking for a resolution described below. If you are experiencing too many issues, you may want to more info Call Sage Technical Support Number