Post reply

SqlAgent Service runs but status is 'red'

  • July 12, 2002 at 12:40 pm

    #432624

    I think it may be login related, too. I've had this happen on an NT4 box.

    Can you shut down the service from the Services menu?

    Next, check to see who is the login id for this service. If you are admin, change it to yourself, or create another account that has admin rights and assign the SQLAgent service login to that.

  • July 17, 2002 at 3:09 am

    #432851

    Hiya,

    Both SqlServer and SqlAgent run under the same NT account.

    Does this account actually need Admin rights? I rather not use an admin for running SqlServer and SqlAgent (some extended xp procedures ran by SqlAgent can actually find this account and password and then have 'unlimited' access to my system: security risk).

    Nope, I can't stop from service window either (it is already stopped according to the windows services control).

    I'm pretty sure it has to do with the Mail issue. Somehow the Agent fails to 'fully' start. From an OS point of view it is started (the executable to start this service has been run), but from a SqlServer point of view it cannot run becuase of the mail issue. So it's somewhere in a in between twillight zone (executable to start has been run succesfully, but the thread itsef not).

    Does that make sense?

    With Kind Regards/Met vriendelijke groet

    Schil

    'It's never ending and never surrendering' Unida 1999


    With Kind Regards/Met vriendelijke groet
    Schil
    'It's never ending and never surrendering' Unida 1999

  • July 17, 2002 at 5:58 am

    #432867

    The account doesn't need to an admin, but it does require you check some registry and file permissions. Here's the relevant Books OnLine page from MSDN:

    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_overview_6k1f.asp

    K. Brian Kelley

    bkelley@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/bkelley/

    K. Brian Kelley
    @kbriankelley

  • July 17, 2002 at 6:16 am

    #432870

    Thanks Brian.

    With Kind Regards/Met vriendelijke groet

    Schil

    'It's never ending and never surrendering' Unida 1999


    With Kind Regards/Met vriendelijke groet
    Schil
    'It's never ending and never surrendering' Unida 1999

Viewing 4 posts - 16 through 18 (of 18 total)

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