Post reply

SQLSERVER AGENT

  • October 13, 2007 at 3:26 pm

    #178396

    Hi

    I have an sqlserver 2000 server.Both MSSQLSERVER and SQLSERVER AGENT are running same account. One day sqlserver agent failed .

    when i tried to start the services through windows services I got message

    agent started and stopped.Please help me how to start the sqlagent without re installing the sqlserver.

    Binu

  • October 14, 2007 at 10:07 am

    #741840

    Please check the SQL error logs and the Windows event logs for messages as to why the agent stopped.

  • October 15, 2007 at 12:20 am

    #741882

    Hi

    I checked event viewer I got this error

    SQLServerAgent could not be started (reason: Unable to connect to server '(local)'; SQLServerAgent cannot start).

    Binu

  • October 15, 2007 at 3:08 am

    #741903

    This normally means the account you use to run SQL Agent does not have logon rights to SQL Server.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

Viewing 4 posts - 1 through 3 (of 3 total)

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