The enlist operation failed (SQLServerAgent: Unable to connect to MSX) (Error: 22026)
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: Unable to connect to
MSX.) (Microsoft SQL Server, Error: 22026)
Cause
This error can occur when setting up Multi Server Administration > Make
this a Master...
Check the log file on the master server (by default located
here: C:\Program Files\Microsoft SQL
Server\MSSQL15.MSSQLSERVER\MSSQL\Log)
2020-07-21 11:59:19.82 Logon Login failed for
user 'TEST2019\SQL2017-2K19-1$'. Reason: Could not find a login matching
the name provided. [CLIENT: 192.168.131.227]
The target server machine account (in this case 'TEST2019\SQL2017-2K19-1$')
does not have permission to login on the master server.
Resolution
This error can be resolved by adding the target server machine account as a
login on the master server.
Comments
Post a Comment