Re: HELP!! SQL Server Agent not working.

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 11/03/05

  • Next message: Bo Sanden: "Row and cell level security" 
    Date: Wed, 02 Nov 2005 21:39:00 -0700

    Is the error actually:
    Error 22022: SQLServerAgent is not currently running so it
    cannot be notified of this action.

    Some things to check - Are you running SQL Server in fiber
    mode (lightweight pooling)? Have you ensured that SQL Agent
    is truly running and not hung up in a starting status? Have
    you checked your sqlagent.out file?
    In addition to lightweight pooling being enabled, Agent can
    also get hung up due to a bad mail profile.

    -Sue

    On 2 Nov 2005 20:13:15 -0800, miguel.a.escalante@gmail.com
    wrote:

    >I was wondering if someone would be so kind as to tell me if i'm
    >missing something or just plain dumb:
    >
    >I am running a 2000 Advanced Server and SQL 2000 Enterprise SP3. I
    >changed the SQL SERVER SERVICE account to use a Local NT User account
    >with no enhanced privileges standard user and another account with the
    >same level of permissions for the SQL SERVER AGENT.
    >
    >Both services start fine and I configured the SQL server to start using
    >the service account thru enterprise manager. As well as the
    >configuration for SQL SERVER AGENT was also done in Enterprise Manager.
    >
    >
    >The file system and Program files directories are configured with the
    >default ACL's. There is no GPO dictating who has the "log on as service
    >right" and both accounts (SERVER & AGENT) have the sysadmin role in
    >SQL.
    >
    >HOWEVER: whenever I try to run a job thru SQL SERVER AGENT it does not
    >run and i get a message stating that the service is not running. This
    >message dissapears as soon as i make the accounts members of the local
    >administrators group.
    >
    >Would there be any way to run these 2 services under the local USER
    >permissions and have the jobs execute sucessfully?
    >
    >ANY HELP would be appreciated. I have been doing research for more than
    >5 days now and can't seem to find an answer.
    >
    >THANks!
    >
    >Miguel A. Escalante, MCSE

  • Next message: Bo Sanden: "Row and cell level security"

    Relevant Pages

    • RE: DTS Package fails when Scheduled
      ... Make sure SQL Server Agent account has the correct rights/permissions. ... scheduled job under this context, I still received the error, even though I ...
      (microsoft.public.sqlserver.dts)
    • Re: Problems with SQL Srv. Agent and Proxy Account
      ... I have tried with both the sa account and with Use Windows ... Authentication on the SQL Server AGent Connection tab. ... >>rights recording to INF: Reset Proxy and the ...
      (microsoft.public.sqlserver.security)
    • Re: cant find directory when package scheduled as job
      ... the batch file to map the drive. ... from the DTS designer but fails when it is scheduled as a SQL Server Agent ... under my windows account and the packages executes correctly when run via ...
      (microsoft.public.sqlserver.dts)
    • Re: Http verification .sms_aut (port 80) failed
      ... I noticed I couldn't get SMS reports to work.... ... MP encountered an error when connecting to SQL Server. ... If using a standard SQL security account, ... SMS_SITE_COMPONENT_MANAGER service to immediately apply the new configuration. ...
      (microsoft.public.sms.admin)
    • Re: Problems with SQL Srv. Agent and Proxy Account
      ... You need to go to the General Tab of the SQL Server Agent ... >I have tried with both the sa account and with Use Windows ...
      (microsoft.public.sqlserver.security)