Tuesday, October 29, 2013

The service was started and then stopped

Sql server agent service issue: My junior DBA met me on an interesting issue. Sql service account is not able to start the Sql server agent whereas Sql server service is running. When he tries to start sql agent service then he gets following issue:
“The request failed or the service didn’t respond in a timely fashion. Consult the event log or other application error logs for details.”
“The service was started and then stopped”
Let’s look at the errorlogs from I:\MSSQL10.MSSQLSERVER\MSSQL\LOG. Following error is observed:
Here is the actual problem: “The service account phx\_ctpfort doesn't have perms to start Eventlog service.”
Lets look at the permsisions:
  1. 1. Run -> cmd -> rsop.msc and press enter.
  2. 2. Click on Windows settings.
  3. 3. Click on System services.
  4. 4. Click the properties on Windows event log.
  5. 5. Click on View security to look for the service account under which the sql service is running.

We need to have it added there. Once added, the problem was resolved.
Please share your feedback and let me know if the blog was useful.

No comments:

Post a Comment