SQL Server advanced replication Debugging Tips _ Database Other
Source: Internet
Author: User
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.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.