Buildmaster - New install and SQL login bug

[Jon]

When you create a new install of Buildmaster (2023.9) it is possible to enter a circular loop with service install if the user installing the application has privileges to SQL but the default service logon user does not.

Steps to reproduce:

1. Install the application using a user which has administrative privileges on the SQL box which by default sets the service to use the NT AUTHORITY\Network Service (default option) privilege.
2. Ensure this user does NOT have access to SQL.
3. Watch the services go in a circular starting state (Buildmaster Web Service and Buildmaster Service).

You can only diaganose this error by examining the event logs which displays the SQL login error. To fix this, you need to add the Network Service user to the SQL box or change the logon user for the services.

This is not good behaviour for Windows Services which already have built in error detection and handling.

Expected behaviour: service fails to start up and gracefully shuts down. Records entry in log.

[atripp]

Hi @Jon ,

Thanks for the note; this behavior is intended, and was decided after many years of supporting products in the field. The service is configured to automatically restart after a crash, and a database error will crash the service.

This is easiest to manage, since most database connection errors (even permissions-based ones) are are temporary in nature, so this behavior means the problem will be automatically resolved.

Best,
Alana