SQL SERVER AGENT Problems

• Chris Borman-167837

  SSC Rookie

  Points: 32

  More actions

  October 10, 2005 at 4:51 am

  #165810

  Need a little bit of help. Had to reboot a server on friday, when the server came

  back up the SQL server Agent would not start, have tried using different

  Service settings including local system and domain user but the service will

  not startup.I have two error messages, the are:

  SQL Server Agent Error Log

  (298) SQL Server Error 229, EXECUTE permission denied on object

  'sp_sqlagent_has_server_access', database 'msdb' owner 'dbo'. [SQLSTATE

  42000] (ConnlsLoginSysAdmin)

  and

  Event error Log

  SQLServerAgent could not be started (reason: SQLServerAgent must be able to

  connect to SQLServer as SysAdmin, but '(Unknown)' is not a member of the

  SysAdmin role).

  I have tried Using a new login set up with domain access, and aliased to dbo

  but still not working any ideas??

  Any advice will be gratefully received, as I'm considering reinstalling SQL

  Server

  

• raj-247939

  SSCertifiable

  Points: 5999

  More actions

  October 10, 2005 at 8:43 pm

  #596424

  Hi Chris,

  Go to Administration manu then to services and try from there to restart ur agent.If it is still not stating then see the settings in sp_configure.

   

  from

  Killer

   

• Chris Borman-167837

  SSC Rookie

  Points: 32

  More actions

  October 11, 2005 at 1:39 am

  #596453

  Great, It works now, found a rogue userid in one of the connection settings.

  That sorted it.