Can not create unsafe assembly

I try to create assembly with UNSAFE permissions.
I granted "unsafe assembly" to my login, set TRUSTWORTHY property ON.
Now I have this error:

Could not obtain information about Windows NT group/user <MyDomain>/<MyName>, error code 0x5. (Microsoft SQL Server, Error: 15404).

How to resolve this



Answer this question

Can not create unsafe assembly

  • Damien fromOZ

    Chad, how to verify connectivity to D.C.
  • madhukeswar

    Looks like your server isn't able to reach the D.C. to get information on your particular user/group...have you verified connectivity to the domain controller



  • Johannes Herbst

    I've gotten that error before. I think the owner of your database doesn't have permission to create assemblies. Try running sp_ChangeDBOwner 'sa' to change the owner of your database to sa.
  • hegde

    On a side note, it isn't recommended setting the TRUSTWORTHY property to ON if you only need to create an unsafe assembly. You can also create an asymmetric key, map a login to that key, and grant UNSAFE permission to the login to create an unsafe assembly. See http://msdn2.microsoft.com/ms345106(en-US,SQL.90).aspx for more info.

  • qUchUnyU

    Good Morning,

    Is this the same Chad Boyd from Mars Hill who used to work for ATX in Caribou, ME  

     ChrisRogeski@gmail.com

     



  • Can not create unsafe assembly