Before you try the Troubleshooting steps, try these first and foremost:
- Disable the Firewalls/Antivirus between the client PC and the server PC. See the Related Resources section of this article for firewall whitelisting processes.
- Are there any hardware firewalls between the PCs that could be in the way? (eg a router?)
Troubleshooting steps:
- Check if the connection manager is running on the server and the workstation.
- Make sure the database opens fine locally on both server and workstation
- Go into explore/tools/folder options/view and unselect “use simple file sharing”
- Check that all computers belong to the same workgroup:
- Right click on “My computer”.
- Go to “Properties”, click on the “Computer Name” tab and compare the names for workgroup on server computer and the other workstation computer
- Use the server’s ip address to open the data from the workstation:
- Find out the ip address of the server/main computer
- In the Open Company window, type the server’s IP address in the File name box (i.e. \\192.168.10.10\) and browse to the folder where the data is stored.
- Verify the connectivity between the workstation and the server:
- On workstation computer, open command prompt and try to telnet the port 13531 on the server.
- If you get any errors when using telnet then:
- Check the firewall settings both on server and workstation computers.
- Check the permissions for the Windows user
- Try logging in Windows as different user
- Open the ports in the firewall
- Power cycle the router for 30 secs
- Open the ports in the router, also if they are using the static ip on the main/server computer they can try to forward the port to the server/main computer’s ip address
- On the server open up the dbengine.ini file found in C:\Program Files\Winsim\ConnectionManager\MySqlBinary\5.0.38and add the line innodb_flush_method=normal.
Note: This line modifies the behavior of the MySQL database and it is untested. This is for servers which are configured with RAID Level 2 or 3. Stop and Start the connection manager.
- Enable Simple File Sharing on the router
- Check the connection speed, if the network connection is too slow, Sage 50 will time out and it will also result in this error message
- Try adding the Server IP address to the workstations hosts file:
- Open Notepad
- Go to File, Open and browse to C:\Windows\system32\drivers\etc\hosts
- Select the hosts file (make sure you are showing all the files in the lower right-hand side)
- Go to the end of this file and add a line with the ip address and the name of the server computer (where the Sage 50 Accounting data is stored). For example: 102.54.94.97 rhino.acme.com
- Configure router to port forward both TCP and UDP with port # 13531 and 13540-13545.
|