This article is for a computer technician who is the administrator of your network.  You must have the Sage 50 Connection Manager installed and running on the server.

Important information

• Sage 50's design and testing don't support a Virtual Network environment (also known as Cloud computing).
• If the shared drive or folder is part of a Distributed File System, then the Sage 50 Connection Manager won’t recognize the folder. Recreate the folder outside of the Distributive folder
• If you set up the drive or folder as a Web Service, then Sage 50 connection manager won’t recognize the drive. Create the folder outside of the Web Service
• If the drive is independent (not configured in the computer's BIOS), then Sage 50 connection manager won’t recognize the drive

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 problems with the IP/Hostname resolution, an error will generate or there will be delays in 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
• Multihoming is problematic for the connection manager

Firewall settings

• Allow the processes and ports through your firewall to ensure that Sage 50 Accounting will operate correctly

Shared folder settings and Sage 50 Database Connection Manager

1. Right-click on your data folder, then select Sharing and Security from the drop-down menu to test user rights for accessing the data.
2. Select the Share folder radio button, then select Permissions.
3. Choose to share with EVERYONE or assigned users and give full permissions to the folder.
4. Test accessing the data from the various workstations.
5. If successful, remove the EVERYONE group from the Permissions tab and add each user in the Shared Permissions instead.
6. If you can't add the users, proceed to the next section.
7. Use the Computer Server Management to add the LAN users.
8. Select Windows Start, Control Panel, Administrative Tools, then Computer Management.
9. Select Local Users and Groups Users and add the user here.
10. Once you add the user, go back to step 1 and add the individual user to the Shared Permissions on the data folder.
11. Try again to open the data across the network.

Add the local server administrator (not global admin)

1. Select Windows Start, Control Panel, Administrative Tools, then Services.
2. Find the Sage 50 Database Connection Manager in the services list and double-click it to open the Properties window.
3. Select the Log On tab. Add the local administrator.
4. Enable the service state, then select OK.
5. Open the Sage 50 Database Connection Manager properties window again.
6. Stop and then Start the Connection Manager service on the server.
7. If you receive a 1069 error message, this means the Connection Manager can't start due to a rights issue.
8. Try again to open up the database across the network.

Configure security policies

1. Press the Windows Key + R.
2. Type in secpol.msc.
3. Scroll through the User Rights Assignments and double-click Log on a service.
4. Add the network users to the logon list.
5. Select OK.
6. Restart the Connection Manager.
   Note: This isn’t the domain permissions but the local permissions for the server.
7. 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.
8. Test the connection again.
9. If the connection is successful and the server needs more than one NIC, use the server's IP address instead of a UNC name.
    EXAMPLE: In the open company window using FILE NAME, type \\192.168.0.2\simplydata\universl or add the server address to the HOSTS file.