Possible problems when the program running as a service tries to write data to the database
In Windows Vista or higher, logging to the database works fine if the program runs as an application, but fails if the program runs as a service.
Such behavior is caused by the Windows security policy. A service is launched with the administrator’s full privileges, but an application may be launched with the administrator’s limited privileges.
1. Run the program with the administrator’s full privileges by right-clicking the program’s icon and selecting “Run as administrator.”
2. Check the program’s settings. Possibly, they are different in this mode.
3. Make sure that the program writes data to the database.
3.1 Database authentication may not allow a connection with such privileges.
3.2 The firewall may block the connection to the database.
4. If everything looks fine but still no data are written to the database, do the following:
4.1. Enable logging of all messages to the program’s log file (Figure 1).
4.2. Launch the service.
4.3. Check the log file in the folder “C:\Users\All Users\Advanced PBX Data Logger\”
Figure 1. Configuring the program’s log file