The EXECUTE permission was denied on the object ‘sp_sqlagent_update_agent_xps’, database ‘msdb’, schema ‘dbo’.

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.

Ekrem Önsoy
Author: Ekrem Önsoy

The original article was written in Turkish by Ekrem Önsoy and translated to English by dbtut with the consent of the author. The copyright of the article belongs to the author. The author shall not be liable in any way for any defect caused by translation.

Leave a Reply

Your email address will not be published. Required fields are marked *