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)

The enlist operation failed (SQLServerAgent: Unable to connect to MSX) (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.

SQL - New Login

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