Although the SQL server service startup type is automatic, the service does not start on restarting the server. If I try to start the service it errors saying "Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: <local machine>]" I have to go into the properties and log on tab and put in the password.
Once this is done the service starts successfully. Any ideas why the SQL server service cannot retain the credentials.