SQL Server agent does not start when the OS starts. When I try to start MSSQLSERVER in Services manually (even though it’s set for Automatic) I get “The MSSQLSERVER service on Local Computer started and then stopped. Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts service.” error message.
Answer:
1. Check that the account that has been assigned for the service (“Log On” tab in the property window of the service). If you have specified an account for this, make sure that correct password has been set.
2.This error occurs if you are using an evaluation copy of SQL Server and the evaluation period is over. To determine if this is cause of the error, check the error log at C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOG (this is the default). You should find the string “SQL Server evaluation period has expired”. ]]>