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)
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:
Comments
Post a Comment