Thursday, May 29, 2008

SQL: Could not obtain information about Windows NT group/user

I received the following error when doing a sql install:

CREATE ASSEMBLY [Dan.ImportFile]
AUTHORIZATION clrUser
FROM 'E:\Dan\SQL\ImportFile.dll' WITH PERMISSION_SET = EXTERNAL_ACCESS

Msg 15404, Level 16, State 19, Line 1
Could not obtain information about Windows NT group/user 'DOMAIN\usersql', error code 0x5.


What I am trying to do is give sql access to a .net assembly through a user/login/assymetric key.

Traversing through the web and looking for the cause led me to the following article:
http://support.microsoft.com/kb/834124


Although this was great, it didnt get me to the final solution. The problem actually ended up being pretty simple. My sql server service is running under a domain account. The domain account password was expired so when the lookup tried to access the active directory we received the error message.

SOLUTION: Update the password on the SQL Server service(s)

Confirmation of the problem could be found in the windows security event log where my DOMAIN\usersql account was failing logon.