I have SQL 2008 sestup specifically for Operations Manager 2007 R2 (SCOM).
Every time I reboot the server, the service account doesn't start and errors out with a logon failure: Windows Could not start the SQL Server Service on Local Computer Error: 1069 The service did not start due to a logon failure.
It's like it's not keeping the password hash on the local system. Putting in the same password again helps until next reboot or just given some time.
I have read articles and recreated the SQL account but happend again a few days later.
Thanks guys/gals :) Happy Valentines day!