Posted on: 12/15/2013 7:59:32 AM | Views : 1631

The sql server agent service is not running on my machine. Sql server 2012 express.
All the other services are running.
This is an extract from the error log;
2013-12-15 12:43:26 - ? [100] Microsoft SQLServerAgent version 11.0.2218.0 (X64 unicode retail build) : Process ID 628 2013-12-15 12:43:26 - ? [495] The SQL Server Agent startup service account is WORKGROUP\ANTHONYPHILL-PC$. 2013-12-15 12:43:26 - ! [298] SQLServer Error: 229, The EXECUTE permission was denied on the object 'sp_sqlagent_update_agent_xps', database 'msdb', schema 'dbo'. [SQLSTATE 42000] (DisableAgentXPs) 2013-12-15 12:43:26 - ! [000] The EXECUTE permission was denied on the object 'sp_sqlagent_update_agent_xps', database 'msdb', schema 'dbo'. [SQLSTATE 42000] (Error 229) 2013-12-15 12:43:26 - ! [298] SQLServer Error: 229, The EXECUTE permission was denied on the object 'sp_sqlagent_update_agent_xps', database 'msdb', schema 'dbo'. [SQLSTATE 42000] (DisableAgentXPs) ...

Go to the complete details ...