Post reply

sql server agent

  • August 23, 2011 at 3:45 am

    #242079

    my sql server agent is not starting ..i have sql server r2 2008 RTM version...it is runnin under local system account and i have admin privilages but still it is not starting..can anyone help me on this????

  • August 23, 2011 at 3:58 am

    #1371847

    check the Windows application event log for messages

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • August 23, 2011 at 3:58 am

    #1371848

    Any error message you are getting?

  • August 23, 2011 at 4:03 am

    #1371850

    Please Go and Check the

    SQLSERVER Configuration Tools-->Configuration Manager

    -->SQL SERVER Services

    It will lists all the SQLServices like Integration Service,Analysis Service,SQL Reporting Service Similar that

    SQLSERVER Agent(yourSQLInstance) Service is present. Right click the Service and Start It.

  • August 23, 2011 at 4:12 am

    #1371855

    Have you checked the sqlagent.OUT file? That will tell you why it's failing. If the file doesn't exist, or the date on it is older than the last time you attempted to start the service, chances are that an invalid location is specified.

    John

  • August 23, 2011 at 9:22 am

    #1372087

    in output file it is mentioned like we don't have sufficient permissions to start the agent

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply