On popular requests from my dear students, I am going to post stuff about Databases and that too on SQL Server. All my next posts will focus on the basics of the SQL Server, its working, SQL and PL/SQL etc. Enjoy all the posts and in case you want to have posts on specific topics, please share at dhandrohit@gmail.com
SQLServer Error: 15404, Could not obtain information about Windows NT group/user Error code 0x5. [SQLSTATE 42000] (ConnIsLoginSysAdmin)
If we encounter this error "SQLServer Error: 15404, Could not obtain information about Windows NT group/user Error code 0x5. [SQLSTATE 42000] (ConnIsLoginSysAdmin)" in SQL Server in which the job fails because of the user account related problem, then we need to take the following steps to make it work: a. Go to SQL Server Agent. b. Then select the job which is giving error and not running successfully. c. Then choose properties and in the General Tab, change the owner to "SA" or any account that has the administrative privileges. The problem will be resolved.
Comments