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.

Contact Us

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.