Error: "Login failed for user NT_AUTHORITY\ANONYMOUS LOGON"

Symptom:
You see the error: "Login failed for user NT_AUTHORITY\ANONYMOUS LOGON" after installing GPSGate with MSSQL server.

Cause:
Using two servers; one for GpsGate and one for the database. This may lead to user right problems.
Following https://forum.gpsgate.com/viewtopic.php?t=11226 may not fully solve the issues.

Solution:

  1. Completely uninstall GpsGate
    https://support.gpsgate.com/hc/en-us/articles/360002881434-Re-install-GpsGate-Server-from-scratch

  2. Create a MSSQL root user in the database.

  3. Install/Restore GpsGate using the newly created MSSQL root user.
    For Restoring see https://support.gpsgate.com/hc/en-us/articles/360002905033-Backup-and-restore-GpsGate-Server