An interesting error occurred recently: some jobs on a database server overseas occasionally reported errors, with the following message:
————————————————————————————————————————————————-
Date 2013/9/15 12:00:00
Log Job History (JOB_SYNCHRONIZING_ESCM_DATA_EAV)
Step ID 0
Server EGVNT02
The job name JOB_SYNCHRONIZING_ESCM_DATA_EAV
Step Name (Job Outcome)
Duration 00:04:34
SQL severity 0
SQL message ID 0
Operators who have been notified by E-mail
An operator who has sent a notification over the network
Operators who have been notified by paging
Retry 0
The message
The job failed. Unable to determine if The owner (domain\login) of job JOB_SYNCHRONIZING_ESCM_DATA_EAV has Server Access (Reason: Could not obtain information about Windows NT group/user ‘domain\login’, error code 0x5. [SQLSTATE 42000] (Error 15404)).
————————————————————————————————————————————————-
The database version, Microsoft SQL Server 2008 R2 (RTM) -10.50.1600.1 (X64), was created using domain\ Login, which has the sysadmin Server role but belongs to Domain A and is not A member of the Administator group within the system. The login account for the database-related services is as follows:
Search the information from the Internet as follows:
This message is thrown if the SQL Server service uses an account that does not have sufficient administrative credentials on the Windows domain. In this situation, the xp_logininfo system stored procedure is run by using the security context of the SQL Server service. Because the account does not have sufficient administrative credentials to enumerate the properties of the user in the domain, the xp_logininfo system stored procedure fails, and you receive the 8198 error. To resolve this problem, change the startup account of the SQL Server service to a Windows domain account.
We need to either run the SQL service under domain account or use SQL authentication
This error message is thrown if the account used by the SQL Server service does not have sufficient administrative credentials. The Windows domain. In this case, the Xp_loginInfo system stored procedure is run in the security context of the SQL Server service. Because the account does not have enough security credentials to enumerate the user’s attributes in the domain, the Xp_loginInfo system stored procedure fails and you receive an 8198 error. To resolve this issue, change the startup account of the SQL Server service to the Windows Domain account.
We need to run the SQL service with the domain account or with SQL authentication.
In fact, it is also very convenient to solve this problem by changing the owner of the job to SA or the account with the role of Sysadmin in the local area. But I’m still confused about the nature of the problem. Why is it that it works most of the time, and occasionally this error occurs?I never understood that.
Resources:
http://www.sqlserver-wiki.com/2012/11/could-not-obtain-information-about.html
Read More:
- SQL Server “login failed for user ‘domain account”. [sqlstate 28000] (error 18456). “Problem solving
- SQL Server 2008 login 4064 error solution
- SQL query time group_ Was cut by group_ CONCAT()
- SQL Server 2008 18456 error and SA unable to login solution
- Win10 account login error report error code: 0x80190001
- Could not launch “” Domain: IDEDebugSessionErrorDomain Code: 3 Failure Rea
- install sql server 2016 Error code 0x84B20001
- SSIS package error report login failed for user’nt authority\anonymous logon’ solution
- Error code 1045, state 28000, Java sql.SQLException :Access denied for user ‘root’@’localhost’
- Make the root user login through SSH and report the error of “permission denied, please try again”
- [Four Solutions] FTP Login Error: 530 Login incorrect.Login failed”
- [solved] sql30082n security processing failed with reason “24” (“user name and / or password invalid”)
- Python flash project to obtain the request user IP address addr
- The solution of Maya exporting obj to sp without identifying group information
- [Transfer] mdt wds deployment windows Litetouch deployment failed, Return Code = -2147467259 0x80004005 solution…
- mdt wds deployment windows Litetouch deployment failed, Return Code = -2147467259 0x80004005
- Prompt SQL server error 15023 solution memo when modifying user mapping
- Error:kCFStreamErrorCodeKey=-2102 Domain=kCFErrorDomainCFNetwork Code=-1001 – iOS
- Login failed for user ‘IIS APPPOOL\DefaultAppPool’
- SQL Server 2012 installation exception: error while enabling windows feature: netfx3, error code: – 2146498298