Error: "Sage 50 cannot connect to its database on 169"
Description
Cause
  • Computer has more than one active network adapter (interface / card / device)
  • This address results from a built in feature of windows called automatic private IP address(APIPA). When your computer is unable to find a DHCP server the APIPA service will assign itself a 169.x.x.x IP address.
  • GWpreference.txt has the hostname entry of "169"
  • ~PVSW~.LOC has a hostname entry of "169"
  • DNS is corrupted
  • Norton VPN
Resolution
[BCB:3:Network warning:ECB]

Option 1: Multiple NICs

Advise the network administrator or IT support to identify the non-active network adapter on the computer and disable it. Editing the hosts file to force resolution to the desired IPv4 address may also help. See below.

Note: Servers using multiple network adapters can function normally if the network adapters are operating in a team as these will operate as one adapters, but not as independent network interfaces.

Option 2: Check GWpreference.txt

  1. Browse to your data path. Follow How to find data path and program path for assistance with finding your data path.
  2. Open the file GWPreference.txt.
  3. Delete the incorrect computer name and enter the correct computer name.
  4. Select File, then Save.
  5. Verify you no longer receive the error when opening.

Option 3: Edit the HOSTS file

  • The problem may also be caused by faulty DNS resolution. Even if pinging the host machine by computer name resolves to the right IP address, it may help to force DNS resolution in the hosts file.
  • See How to add a hosts file entry
  1. Run Notepad as an Administrator and open C:\Windows\System32\drivers\etc\hosts.
  2. Add an entry at the bottom for the IP address of the server and the name of the host.
    Example: 10.129.38.27 sageserver1

Option 4: Edit the ~PVSW~.LOC file

  1. Open the ~PVSW.LOC~ file in Notepad.
  2. Edit the computer name and save the change.

Option 5: Turn off Norton VPN

  1. Turn off Norton 365 VPN to activate Sage.
  2. After it is activated you can re-enable Norton VPN.

[BCB:161:Chat 50 US:ECB]
Steps to duplicate
Related Solutions