SQL Server advanced replication Debugging Tips _ Database Other

Replication Error Troubleshooting Cases

Wang Jing is

First, configuration error

1.  Behavior: SQL Server scheduled Job ' Replication agent check ' (0X8B6402EFE814B543A112E5A5A5FBB8CF)-Status: Failed-invoked on:2007-07-20 08:50:01  -Message: Job failed. Unable to determine whether the owner (Wangjingzheng\administrator, owns the job replication agent check) has access to the server (reason: failed to get information about Windows NT Group/user ' wangjingzheng\ Administrator ' information. [SQLSTATE 42000] (Error 8198)).

2. Troubleshooting steps: Appears to be caused by NT users, the registration of SQL Server changed to SA, no NT method, the result is successful. After checking the server's full name, the server has become more domain controllers, Domain name is learn.com, then the whole sentence is wangjingzheng.learn.com, so that the reason for the failure is: The server is upgraded to a domain controller in SQL Server before its built-in NT login account for wangjingzheng\ Administrator, and this time the server has been upgraded, the user sentence should be learn\administrator, so the original account has been invalidated.

3. Remove the original wangjingzheng\administrator, add the admin account learn\administrator again, and then reconfigure the problem.

4. In this connection, check that the startup account for SQL Server and SQLServerAgent services is still. \administrator, and you can change it to a domain account.