You can check this from a cmd window, issuing this command: net user SomeUser /domain This is very easy to check: does the user exist in Windows? Did you misspell the name? Understanding where the error comes from can be tricky, but it can become easier to troubleshoot when you understand what happens behind the scenes and what are the most likely causes. This happens every time SQLServer tries to query information about the Windows user from Active Directory and receives an error. However, in some cases, the command fails with the infamous error message: Could not obtain information about Windows NT group/user 'MyDomain\SomeUser', error code 0x5 If everything is configured correctly, you will see a list of Windows accounts and the login(s) they are mapped to in SQLServer. EXEC xp_logininfo 'MyDomain\SomeUser','all'
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |