WINDOWS 2008
闲说几个BLOG系统的选
SQL Server 2005 Replication agent checkup 登录错误 
今天收到一封信,是从ATOS数据库服务器代理那儿发来的,说发现服务器运行有错误:
The job failed. Unable to determine if the owner (域\用户) of job Replication agents checkup has server access (reason: Could not obtain information about Windows NT group/user '域\用户', error code 0x5. [SQLSTATE 42000] (Error 15404)).
I did not find any login by the name 域\用户 on the server, but there was user on database PVTxxxx05 by the same name and it mapped on to login mySQLLOGINNAME which had dbo rights on the database.
The error [SQLSTATE 42000] (Error 15404) most likely means the machine account doesn't have permission to query the Active directory, cause generally the local service does not have any rights to query / check the identity of the connecting user.
Changing the job owner to sa might solve the issue.
Kindly look into it and suggest on it.
