Could not obtain information about Windows NT group/user ‘domainuser’, error code 0x5. [SQLSTATE 42000] (Error 15404) (ConnIsLoginSysAdmin)

2017-12-11T16:21:28+00:00 March 1st, 2013|Windows|0 Comments

Recently encountered an issue in SQL when running SQL Agent Jobs would give the following error in the agent jobs log:

Could not obtain information about Windows NT group/user ‘domainuser’, error code 0x5. [SQLSTATE 42000] (Error 15404)(ConnIsLoginSysAdmin)

The solution to this is to add the SQL Server service account to the ‘BUILTINWindows Authorization Access Group’ on your DC.

You can then run “EXECUTE AS USER = ‘domainuser’” on SQL Server to check.

Cheers,

Jason.

Leave A Comment

like what you see? 

Sign-up to our newsletter and never miss out on the latest blogs, events and tech news from the world of risual
SUBSCRIBE!
Give it a try, you can unsubscribe anytime.