The service did not start due to logon failure.

Error:

Getting the following error when trying to set a network account to run SQL Server service.

The service did not start due to logon failure.

Fix:

Make sure the network account has “logon as a service” permission.

Enable service log on permission for Run As accounts

Go to Administrative Tools and select Local Security Policy. Expand Local Policy and select User Rights Assignment. In the right pane, right-click Log on as a service and select Properties. Select Add User or Group option to add the new user.