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

Post a Comment

Popular posts from this blog

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

-
Image
This post describes how to fix the error "This app will now restart to free up more memory" which can occur when using apps such as Netflix on an LG TV after just a few minutes of use. Resolution To resolve the issue, unplug the TV then press the on/off button for 10 seconds.  Wait a further 20 seconds then plug the TV back in and turn it back on. Apps should now run without the error. Edit: The on/off button on my LG TV is directly under the standby light on the bottom of the TV. Edit: I didn't have to do this myself but one person who has left a comment said that clearing all browsing data worked for them.  I have written a post explaining how to do this: LG TV Clear All Browsing History Data . Edit: A few other people have also suggested turning off quick start in settings (and if it's already off, turn it on then off again).  I have written a post explaining how to do this: LG TV turn off Quick Start in settings Related Posts -  LG TV delete/rem...
Read more

What is the "W" light on a Steelseries keyboard?

-
Image
This post describes what the light marked "W" on a Steelseries Apex keyboard is. This is the fourth light in the row located in the top right corner of the keyboard, next to the Scroll Lock "S" light. The "W" light on a Steelseries Apex Keyboard This light indicates that the Windows key has been disabled.  So, when you're gaming, if you accidentally press the Windows key, you will stay in the game instead of being taken to the Windows desktop. How to turn the "W" light on or off? The "W" light on a Steelseries Apex keyboard can be turned on or off by pressing and holding the special Steelseries function key down, then pressing the Windows key. Related Posts -  Steelseries Sensei Ten squeaky scroll wheel
Read more

Excel Import CSV not using "Use First Row as Headers"

-
Image
Issue When importing a CSV file into Microsoft Excel, you may find that it is not using "Use First Row as Headers" so you end up with Column1, Column2 etc as headers. Resolution To resolve this issue, press the Transform Data button in the bottom right. This loads the Power Query Editor which includes the "Use First Row as Headers" option in the Home ribbon.  Press this option once. Press Close & Load to apply. The first row is now being used as headers: Related Posts - Open a Microsoft Excel spreadsheet xlsx file as read only
Read more