SQL Server advanced troubleshooting

Duplicate error troubleshooting Cases

Wang jingzheng

1. Configuration Error

1. symptom: SQL Server scheduled job 'Copy proxyProgramCheck '(0x8b6402efe814b543a%e5a5a5fbb8cf)-Status: Failed-invoked on: 08:50:01-message: Job failed. Unable to determine whether the owner (wangjingzheng \ Administrator, with job replication agent check) has permission to access the server (cause: unable to obtain information about the Windows NT group/user 'wangjingzheng \ admin. [SQL state 42000] (error 8198 )).

2. troubleshooting steps: It seems that it was caused by the NT user. The registration of sqlserver is changed to SA, and the result is successful without the NT method. After checking the full name of the server, it is found that the server has been changed to a domain controller and the domain name is learn.com. Then the full sentence is wangjingzheng.learn.com. The cause of the failure is: before the server is upgraded to a domain controller, its built-in nt Logon account in sqlserver is wangjingzheng \ administrator. When the server is upgraded, the user sentence should be learn \ administrator, so the original account has expired.

3. Delete the original wangjingzheng \ administrator, re-Add the Administrator account learn \ administrator, and then reconfigure the Administrator to troubleshoot the problem.

4. Then, contact us to check whether the startup accounts of SQL Server and SQLServerAgent are still. \ administrator. You can change them to a domain account.