Advantage Database Server Cannot Authenticate

Problem: After installing Unwired Platform, with a high-availability data tier cluster (using Microsoft Cluster Service or Failover Clustering), this error message displays in the event viewer: 7078: The Advantage Database Server cannot authenticate the user. Make sure the name and password are correct.. axServerConnect AdsConnect.

Explanation: This typically indicates that the Unwired Server messaging service cannot locate the shared cluster storage resource that houses database files for the data tier.

Solution:
  1. On a data tier host, check the following registry key value to find the location of the adsserver.ini file: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\Advantage\Configuration\TPS_LOGS. By default it is set to: C:\
  2. If the adsserver.ini file does not exist, create it in the location cited, on each data tier node in the cluster.

  3. Add the following lines to the adsserver.ini file, on each data tier host, to identify the physical path to the shared cluster storage resource:
    [ServerAliases]
    <network_share_name>=<local_path>
    In this example, Data is the network share name, and F:\ is the local path of the share folder on each node.
    [ServerAliases]
    Data=F:\
  4. Restart the Advantage Database Server service.