Problem:

Unable to start SQL Server services.

Error:

Error 1069: The service did not start due to a logon failure.

Fix:

1. Make sure service account running the service is part of the “Backup Operators” group on the local computer.

Control Panel\User Accounts\User Accounts -> Manage User Accounts

2. Make sure the service account running the service is able to log on as a service.

Local Security Policy -> Local Policies -> User Rights Assignment -> “Log on as a service”

Last modified: July 7, 2020

Author

Comments

Write a Reply or Comment