Skip to main content
Commonmark migration
Source Link

I am trying to Configure the Master target server / Multi server environment in Sql Server 2012.

I changed :

  • MSXENCryptChannnelOptions-->Changed from 2 to 0
  • AllowDownloadedJobsToMatchProxyName - changed from 0 to 1 on the target

When I run the wizard I am getting below error

MSX Enlist failed for Job Server 'MasterServerName'

 

The enlist operation Failed(Reason:SQL Server Agent Error: Unable to connect to MSX 'MasterServerName'(Microsoft Sql Server, Error : 22026)

They both servers SQL Agents are running on the same windows service account.

Any Suggestions on how to fix this?

Adding the Log:

Enlist TSX Progress

  • Create MSXOperator (Success) Checking for an existing MSXOperator.

Updating existing MSXOperator.

Successfully updated MSXOperator.

  • Make sure the Agent service for 'Test3' is running (Success) The service 'SQLSERVERAGENT' is running.

  • Ensure the agent startup account for 'Test4' has rights to login as a target server (Success)

Checking to see if the startup account for 'Test4' already exists.

Login exists on server.

Checking to see if login has rights to msdb.

Login has rights to msdb.

Checking to see if user is a member of the TargetServersRole.

User is a member of the TargetServersRole.

  • Enlist 'Test4' into 'Test3' (Error)

Enlisting target server 'Test4' with master server 'Test3'.

Using new enlistment method.

Messages

MSX enlist failed for JobServer 'Test4'. (Microsoft.SqlServer.Smo)


ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)


The enlist operation failed (reason: SQLServerAgent Error: Unable to connect to MSX 'TEST3'.) (Microsoft SQL Server, Error: 22026)

I am trying to Configure the Master target server / Multi server environment in Sql Server 2012.

I changed :

  • MSXENCryptChannnelOptions-->Changed from 2 to 0
  • AllowDownloadedJobsToMatchProxyName - changed from 0 to 1 on the target

When I run the wizard I am getting below error

MSX Enlist failed for Job Server 'MasterServerName'

 

The enlist operation Failed(Reason:SQL Server Agent Error: Unable to connect to MSX 'MasterServerName'(Microsoft Sql Server, Error : 22026)

They both servers SQL Agents are running on the same windows service account.

Any Suggestions on how to fix this?

Adding the Log:

Enlist TSX Progress

  • Create MSXOperator (Success) Checking for an existing MSXOperator.

Updating existing MSXOperator.

Successfully updated MSXOperator.

  • Make sure the Agent service for 'Test3' is running (Success) The service 'SQLSERVERAGENT' is running.

  • Ensure the agent startup account for 'Test4' has rights to login as a target server (Success)

Checking to see if the startup account for 'Test4' already exists.

Login exists on server.

Checking to see if login has rights to msdb.

Login has rights to msdb.

Checking to see if user is a member of the TargetServersRole.

User is a member of the TargetServersRole.

  • Enlist 'Test4' into 'Test3' (Error)

Enlisting target server 'Test4' with master server 'Test3'.

Using new enlistment method.

Messages

MSX enlist failed for JobServer 'Test4'. (Microsoft.SqlServer.Smo)


ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)


The enlist operation failed (reason: SQLServerAgent Error: Unable to connect to MSX 'TEST3'.) (Microsoft SQL Server, Error: 22026)

I am trying to Configure the Master target server / Multi server environment in Sql Server 2012.

I changed :

  • MSXENCryptChannnelOptions-->Changed from 2 to 0
  • AllowDownloadedJobsToMatchProxyName - changed from 0 to 1 on the target

When I run the wizard I am getting below error

MSX Enlist failed for Job Server 'MasterServerName'

The enlist operation Failed(Reason:SQL Server Agent Error: Unable to connect to MSX 'MasterServerName'(Microsoft Sql Server, Error : 22026)

They both servers SQL Agents are running on the same windows service account.

Any Suggestions on how to fix this?

Adding the Log:

Enlist TSX Progress

  • Create MSXOperator (Success) Checking for an existing MSXOperator.

Updating existing MSXOperator.

Successfully updated MSXOperator.

  • Make sure the Agent service for 'Test3' is running (Success) The service 'SQLSERVERAGENT' is running.

  • Ensure the agent startup account for 'Test4' has rights to login as a target server (Success)

Checking to see if the startup account for 'Test4' already exists.

Login exists on server.

Checking to see if login has rights to msdb.

Login has rights to msdb.

Checking to see if user is a member of the TargetServersRole.

User is a member of the TargetServersRole.

  • Enlist 'Test4' into 'Test3' (Error)

Enlisting target server 'Test4' with master server 'Test3'.

Using new enlistment method.

Messages

MSX enlist failed for JobServer 'Test4'. (Microsoft.SqlServer.Smo)


ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)


The enlist operation failed (reason: SQLServerAgent Error: Unable to connect to MSX 'TEST3'.) (Microsoft SQL Server, Error: 22026)

added 1644 characters in body
Source Link
user3325655
  • 337
  • 1
  • 5
  • 14

I am trying to Configure the Master target server / Multi server environment in Sql Server 2012.

I changed :

  • MSXENCryptChannnelOptions-->Changed from 2 to 0
  • AllowDownloadedJobsToMatchProxyName - changed from 0 to 1 on the target

When I run the wizard I am getting below error

MSX Enlist failed for Job Server 'MasterServerName'

The enlist operation Failed(Reason:SQL Server Agent Error: Unable to connect to MSX 'MasterServerName'(Microsoft Sql Server, Error : 22026)

They both servers SQL Agents are running on the same windows service account.

Any Suggestions on how to fix this?

Adding the Log:

Enlist TSX Progress

  • Create MSXOperator (Success) Checking for an existing MSXOperator.

Updating existing MSXOperator.

Successfully updated MSXOperator.

  • Make sure the Agent service for 'Test3' is running (Success) The service 'SQLSERVERAGENT' is running.

  • Ensure the agent startup account for 'Test4' has rights to login as a target server (Success)

Checking to see if the startup account for 'Test4' already exists.

Login exists on server.

Checking to see if login has rights to msdb.

Login has rights to msdb.

Checking to see if user is a member of the TargetServersRole.

User is a member of the TargetServersRole.

  • Enlist 'Test4' into 'Test3' (Error)

Enlisting target server 'Test4' with master server 'Test3'.

Using new enlistment method.

Messages

MSX enlist failed for JobServer 'Test4'. (Microsoft.SqlServer.Smo)


ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)


The enlist operation failed (reason: SQLServerAgent Error: Unable to connect to MSX 'TEST3'.) (Microsoft SQL Server, Error: 22026)

I am trying to Configure the Master target server / Multi server environment in Sql Server 2012.

I changed :

  • MSXENCryptChannnelOptions-->Changed from 2 to 0
  • AllowDownloadedJobsToMatchProxyName - changed from 0 to 1 on the target

When I run the wizard I am getting below error

MSX Enlist failed for Job Server 'MasterServerName'

The enlist operation Failed(Reason:SQL Server Agent Error: Unable to connect to MSX 'MasterServerName'(Microsoft Sql Server, Error : 22026)

They both servers SQL Agents are running on the same windows service account.

Any Suggestions on how to fix this?

I am trying to Configure the Master target server / Multi server environment in Sql Server 2012.

I changed :

  • MSXENCryptChannnelOptions-->Changed from 2 to 0
  • AllowDownloadedJobsToMatchProxyName - changed from 0 to 1 on the target

When I run the wizard I am getting below error

MSX Enlist failed for Job Server 'MasterServerName'

The enlist operation Failed(Reason:SQL Server Agent Error: Unable to connect to MSX 'MasterServerName'(Microsoft Sql Server, Error : 22026)

They both servers SQL Agents are running on the same windows service account.

Any Suggestions on how to fix this?

Adding the Log:

Enlist TSX Progress

  • Create MSXOperator (Success) Checking for an existing MSXOperator.

Updating existing MSXOperator.

Successfully updated MSXOperator.

  • Make sure the Agent service for 'Test3' is running (Success) The service 'SQLSERVERAGENT' is running.

  • Ensure the agent startup account for 'Test4' has rights to login as a target server (Success)

Checking to see if the startup account for 'Test4' already exists.

Login exists on server.

Checking to see if login has rights to msdb.

Login has rights to msdb.

Checking to see if user is a member of the TargetServersRole.

User is a member of the TargetServersRole.

  • Enlist 'Test4' into 'Test3' (Error)

Enlisting target server 'Test4' with master server 'Test3'.

Using new enlistment method.

Messages

MSX enlist failed for JobServer 'Test4'. (Microsoft.SqlServer.Smo)


ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)


The enlist operation failed (reason: SQLServerAgent Error: Unable to connect to MSX 'TEST3'.) (Microsoft SQL Server, Error: 22026)

edited tags
Link
user3325655
  • 337
  • 1
  • 5
  • 14
Loading
added 17 characters in body
Source Link
Kin Shah
  • 62.4k
  • 6
  • 122
  • 241
Loading
Added tag.
Link
Vérace
  • 30.6k
  • 9
  • 71
  • 84
Loading
Source Link
user3325655
  • 337
  • 1
  • 5
  • 14
Loading