snyderkv
asked on
SQL account logon failure?
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.
Any ideas?
Thanks guys/gals :) Happy Valentines day!
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.
Any ideas?
Thanks guys/gals :) Happy Valentines day!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Login as service was probably it. Debug programs was required for something else part of the application I'm using SQL for, I think.
Thanks
Thanks
ASKER
Login As Service
ASKER
I do have logon as service right, but I'll have to look further into what policy may be causing this.