SQL Server Service Did Not Start Due to a Logon Failure
This is an error that I have received a couple of times previously. The first time I couldn't understand what was going on, as I didn't change my SQL password or anything...
After some investigation I saw that this is due to SQL Server logging on with a domain account and my domain password expired and I changed it.
Quickfix:
1. Go to Services in Administrative tools.
2. Open MSSQLSERVER and click on the Log On type.
3. Enter your domain password.
And voila! - your SQL is back to normal.
What you should probably do: (I am guessing here, couldn't find the real solution)
Create a seperate domain account for SQL Server.
Grant this user permission to the SQL Server directory, the .mdf, .ldf files, access to the SQL registry keys.
And let the service log in as this user.
I am open for suggestions on the real solution or the best practise for this.... :)
