SQL Server Performance

SQL 2005 Agent Service not started

Discussion in 'SQL Server 2005 General DBA Questions' started by georgej, Jun 1, 2007.

  1. georgej New Member

    I am not able to start SQL Server 2005 Agent Service. Current I have SP2 installed.
    The error message shows: "SQLAgent$SQL2005 service started and then stopped".

    Are there any ideas on this kind issues?


    Thanks for help!

    George
  2. satya.sqldba New Member

    What was the last major change you made to your server configuration?

    The error most probably would have been due to insufficient previlages of the service account. Make sure the service account has admin previlages.

    By the way, did you make any changes to data files location or try renaming them?

    Also check for the messages in the log.

    Satya
  3. MohammedU New Member

    Check the sql error log and sql agent log for more details and also check the system log and post the error what you are getting...


    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.

Share This Page