Cannot start sqlagent from the config manager, getting the following error
2011-05-14 22:26:29 - ! [298] SQLServer Error: 15247, User does not have permission to perform this action. [SQLSTATE 42000] (DisableAgentXPs)
2011-05-14 22:26:29 - ! [298] SQLServer Error: 229, The EXECUTE permission was denied on the object 'sp_sqlagent_has_server_access', database 'msdb', schema 'dbo'. [SQLSTATE 42000] (ConnIsLoginSysAdmin)
2011-05-14 22:26:29 - ! [298] SQLServer Error: 229, The EXECUTE permission was denied on the object 'sp_sqlagent_get_startup_info', database 'msdb', schema 'dbo'. [SQLSTATE 42000]
2011-05-14 22:26:29 - ! [298] SQLServer Error: 229, The UPDATE permission was denied on the object 'sysalerts', database 'msdb', schema 'dbo'. [SQLSTATE 42000] (DumpAndCheckServerVersion)
2011-05-14 22:26:29 - ! [298] SQLServer Error: 229, The INSERT permission was denied on the object 'syssessions', database 'msdb', schema 'dbo'. [SQLSTATE 42000]
2011-05-14 22:26:29 - ! [000] Error creating a new session
2011-05-14 22:26:30 - ? [098] SQLServerAgent terminated (normally)
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.