What Do I Do if Workstations Are Not Able to Connect to the Database?

Workstations may not be able to connect to the Database due to multiple available IP addresses for the Server in which Acctivate is installed. There are several workarounds.

Workstations may not be able to connect to the Database due to multiple available IP addresses for the Server in which Acctivate is installed on. In some very specific scenarios, Workstations may not be able to connect to the SQL Server when launching Acctivate. The exact cause is still somewhat unknown. Here are some of the scenarios in which this may happen:

• If your physical Server computer has multiple IP Addresses (192.168.1.1 – 4), but SQL Server is listening on just one or a few of these available server ports (192.168.1.1).
• If your physical Server is using IPv4 and IPv6 local link addresses, but SQL Server is listening on an IPv4 address.

There are a couple of simple workarounds for this.

1. On the Workstation, disable the Windows Firewall. This may allow SQL Server to properly communicate using the IP address that SQL Server is listening on.
2. In Database Maintenance -> Database -> Database Sources, change the Servername for both the MSDE and ACCTivate Data Sources to be the IP Address instead of the name of the Computer. For instance, change ‘SERVER\ACCTIVATE’ to be the IPv4 Address of your server, such as ‘192.168.1.1\ACCTIVATE’. Save your changes and close Database Maintenance.

Contact Acctivate Support if you require further assistance.