patternMinor
Targeting MSX with job on Multi-Server Administration
Viewed 0 times
multiwithmsxtargetingadministrationserverjob
Problem
I am using Multi-Server Administration to execute jobs on multiple targets. This works well, but I am not able to enlist the master as a target. I receive the following error when attempting to enlist the MSX as a TSX:
Server 'XXXXX' is an MSX. Cannot enlist one MSX into another MSX.
(Microsoft SQL Server, Error: 14299)
I would think that running these same jobs on the master would not require managing a local job as well as the multi-server jobs.
Any help is appreciated.
Server 'XXXXX' is an MSX. Cannot enlist one MSX into another MSX.
(Microsoft SQL Server, Error: 14299)
I would think that running these same jobs on the master would not require managing a local job as well as the multi-server jobs.
Any help is appreciated.
Solution
Based on my understanding, the master server (MSX) cannot be a target server (TSX) that receives jobs from another master server i.e You cannot list one MSX server into another MSX, you have to defect it and make sure it is not enlisted with any other master server.
Its a simple two-level hierarchy: a server is a master server, a target server, or neither. Cannot be both at the same time.
FROM BOL :
When creating a multiserver environment, consider the following:
You may also want to read up : SQL Server Multiserver Administration: Master and Target Servers
Its a simple two-level hierarchy: a server is a master server, a target server, or neither. Cannot be both at the same time.
FROM BOL :
When creating a multiserver environment, consider the following:
- Each target server reports to only one master server. You must defect a target server from one master before you can enlist it into a different one.
- The master and target servers must be running on the Windows NT 4.0 or Windows 2000 operating system.
- When changing the name of a target server, you must defect it before changing the name and reenlist it after the change.
- If you want to dismantle a multiserver configuration, you must defect all the target servers from the master server.
You may also want to read up : SQL Server Multiserver Administration: Master and Target Servers
Context
StackExchange Database Administrators Q#47438, answer score: 2
Revisions (0)
No revisions yet.