problem in starting sql server agent

• sree-226516

  SSCrazy

  Points: 2590

  More actions

  May 18, 2005 at 2:08 pm

  #110446

  When I trying to start the sqlserver agent I am getting folowing errors in agent error log.

   

   

  [298] SQLServer Error: 229, EXECUTE permission denied on object 'sp_sqlagent_has_server_access', database 'msdb', owner 'dbo'. [SQLSTATE 42000] (ConnIsLoginSysAdmin)

   

   

  [298] SQLServer Error: 229, EXECUTE permission denied on object 'sp_sqlagent_get_startup_info', database 'msdb', owner 'dbo'. [SQLSTATE 42000] 

   

  [000] SQLServerAgent must be able to connect to SQLServer as SysAdmin, but '(Unknown)' is not a member of the SysAdmin role .

   

   

  could anybody please tell me what could be the problem.

   

  Thanks,

  Sree

  Thanks,
  SR

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  May 18, 2005 at 2:28 pm

  #559715

  Verify if SQL Server service account has 'sysadmin' right in SQL Serevr logins.

• Nigel Cook

  Newbie

  Points: 1

  More actions

  June 6, 2005 at 10:26 pm

  #563389

  Sree,

  Check that SQLAgent is using the correct connection credentials (Connections Tab in SQLAgent Properties).

   

  Hope this helps

  Nigel.