ERROR:
[298] SQLServer Error: 229, The EXECUTE permission was denied on the object ‘sp_sqlagent_update_agent_xps’, database ‘msdb’, schema ‘dbo’. [SQLSTATE 42000] (DisableAgentXPs)EXPLANATION:
You may experience this error when you try to run the SQL Server Agent service. The problem is that the Windows (Local or Domain) account that you use to run SQL Server Agent service is not a “sysadmin” Fixed Server Role member in the corresponding SQL Server Instance.
SOLUTION:
Using SQL Server Configuration Manager or Services.msc, you can find which account is being used for the SQL Server Agent service.
For this account, make sure that there is a login in the SQL Server instance to which this SQL Server Agent belongs. And make sure that this login is also a member of the sysadmin Fixed server role. After you authorize it, you can try to run the SQL Server Agent service again.
