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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment