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.
Thursday, May 29, 2008
Subscribe to:
Posts (Atom)