报错信息是:
The job failed. Unable to determine if the owner (Domain\User) of job JobName File has server access (reason: Could not obtain information about Windows NT group/user 'Domain\User, error code 0x6fd. [SQLSTATE 42000] (Error 15404)).我百度上查了
I have jobs running on several SQL Serfer 2005 server running at or above build nimber 9.00.4229. The jobs will run for days with out error and then we will receive the same error reported here. When the job fails I habe just restarted the job and it will run as normal. The SQL Server Agent is runnig with a Domain account which is a local Administrator. The owner account for the jobs in question changes based on the DBA that built the Job/Maintenance Plan. All DBA have Local Aministrator permissions and are also a SQL admin on the respective server. The OS is at Windows Server 2003 SP1.We have even changed the owned of the job to be a differant DBA account and rescheduled the job. The job will run for a period of time and will fail with the same error for no reason.Does anyone have a valid solution for this issue?
不明白说的是什么意思??
求助大家帮忙
The job failed. Unable to determine if the owner (Domain\User) of job JobName File has server access (reason: Could not obtain information about Windows NT group/user 'Domain\User, error code 0x6fd. [SQLSTATE 42000] (Error 15404)).我百度上查了
I have jobs running on several SQL Serfer 2005 server running at or above build nimber 9.00.4229. The jobs will run for days with out error and then we will receive the same error reported here. When the job fails I habe just restarted the job and it will run as normal. The SQL Server Agent is runnig with a Domain account which is a local Administrator. The owner account for the jobs in question changes based on the DBA that built the Job/Maintenance Plan. All DBA have Local Aministrator permissions and are also a SQL admin on the respective server. The OS is at Windows Server 2003 SP1.We have even changed the owned of the job to be a differant DBA account and rescheduled the job. The job will run for a period of time and will fail with the same error for no reason.Does anyone have a valid solution for this issue?
不明白说的是什么意思??
求助大家帮忙
服务器 XXXXXX\XXXXXX
作业名称 XXXXXXXXXX
步骤名称 运行代理。
持续时间 00:01:31
SQL 严重性 0
SQL 消息 ID 0
已通过电子邮件通知的操作员
已通过网络发送通知的操作员
已通过寻呼通知的操作员
重试次数 10消息
The replication agent encountered an error and is set to restart within the job step retry interval. See the previous job step history message or Replication Monitor for more information. NOTE: The step was retried the requested number of times (10) without succeeding. The step failed.
消息
The job failed. The Job was invoked by Schedule 134 (复制代理计划。). The last step to run was step 3 (检测无日志记录的代理关闭。).
消息
Executed as user: NT AUTHORITY\SYSTEM. 复制-复制分发子系统: 代理 CSMDB\CSMDB-CSM-csmplan_wjj0819-PLANDB-34 失败。The replication agent encountered an error and is set to restart within the job step retry interval. See the previous job step history message or Replication Monitor for more information. NOTE: The step was retried the requested number of times (10) with [SQLSTATE 42000] (Error 14151). The step failed.