SQL Server Performance

Error in starting new sqlserver agent

Discussion in 'SQL Server 2005 General DBA Questions' started by raagi2000, Apr 12, 2006.

  1. raagi2000 New Member

    i am a newbie to sql 2005. just installed the sql 2005/win2003 and created databases. now i am trying to schedule the job. unfortunately i do not able to start sqlserver agent.
    the agent is running on domain admin account.

    "SQLServerAgent could not be started (reason: Error creating a new session)"

    any idea's . i never faced this problem in sql 2000.

    thanks
  2. Luis Martin Moderator

    Any messages in even viewer?

    Luis Martin
    Moderator
    SQL-Server-Performance.com

    Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
    Leonardo Da Vinci

    Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte


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



  3. vbkenya New Member

    Can't edit Luis' post: He means "event viewer". Also check The SQL Server "Event Log".

    Just a thought: Is the agent enabled?



    Nathan H. Omukwenyi
    MVP [SQL Server]
  4. raagi2000 New Member

    the above message is from event viewer only
    i do not see any entries in sql error log.
  5. satya Moderator

    Each time the SQL Server Agent Service starts, it creates a new session that is assigned a session number. This session number is an incremental integer and is stored in the syssessions table in msdb. Performing a query (select * from msdb..syssessions) on the syssessions table reveals the results.

    Also check whether the account password is still valid that is used to start SQLAgent service, make sure there are no recent changes to the security policy on the windows environment.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  6. raagi2000 New Member

    Satya

    sqlagent is running under the same account as mssqlservice. no problem with database service.
    getting the error (eventviewer)

    SQLServerAgent could not be started (reason: Error creating a new session).

    infact it the new box , new installation etc. no security policy changes.

    thanks
  7. satya Moderator

    Have you tried to start from Administrative tools --> Services --> SQLAGent service, for a change try to start using local system account or with a local account. Also check SQLAgent log for more information.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  8. raagi2000 New Member

    i tried all way to start up the sqlagent , it is not coming up.

Share This Page