☰

在 Sql Server 2012 中设置多服务器环境 - 登记失败错误

tag-icon • tag-icon database-administration sql-server-2012
在 Sql Server 2012 中设置多服务器环境 - 登记失败错误

我正在尝试在 Sql Server 2012 中配置主目标服务器/多服务器环境。

我变了 ：

MSXENCryptChannnelOptions  # Changed from 2 to 0
AllowDownloadedJobsToMatchProxyName # changed from 0 to 1 on the target

当我运行向导时出现以下错误

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)

两台服务器的 SQL 代理都在同一个 Windows 服务帐户上运行。

添加日志：

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.

消息

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)

答案1

我更改了主服务器和目标服务器上的 SQL Server 代理的服务帐户，并且它起作用了。

相关内容