The EXECUTE permission was denied on the object 'sp_enlist_tsx', database 'msdb', schema 'dbo' (Error 229)

This post describes how to fix the error:
MSX enlist failed for JobServer
An exception occurred while executing a Transact-SQL statement or batch.
The enlist operation failed (reason: SQLServerAgent Error: The EXECUTE permission was denied on the object 'sp_enlist_tsx', database 'msdb', schema 'dbo'. [SQLSTATE 42000] (Error 229).) (Microsoft SQL Server, Error: 22026)

The EXECUTE permission was denied on the object 'sp_enlist_tsx', database 'msdb', schema 'dbo' (Error 229)


Cause

This error can occur when the target server machine account does not have sufficient privileges on the master server.

Resolution

Check the server roles of the target server machine account on the master server.

On my test environment, I resolved the issue by assigning the account the sysadmin server role:

SQL Login Server Roles

Related Posts


Comments

Popular posts from this blog

LG TV This app will now restart to free up more memory

LG TV Clear All Browsing History Data

LG TV turn off Quick Start in settings