Search code examples
.netsql-serverclrsqlclr

Could not load file or assembly … or one of its dependencies. Exception from HRESULT: 0x80FC3C2C

Exception message: Could not load file or assembly System.DirectoryServices or one of its dependencies. Exception from HRESULT: 0x80FC3C2C

Exception raised from CLR SQL procedure. Exception raised from the method in the assembly where one of the classes from System.DirectoryServices is initialized and that assembly is used by the assembly with CLR procedure.

Environment:

  1. MS SQL Server 2005 Std.
  2. .NET framework 2.0
  3. Database where assembly is created has parameter TRUSTWORTHY set to ON
  4. Assembly created with PERMISSION_SET = UNSAFE
Solution

  • Finally, I found the workaround. I added the reference to the System.DirectoryServices to the assembly that is linked to the MS SQL and in the CLR procedure code create a class from this namespace. And so System.DirectoryServices assembly became visible from the class where the main code for DS is placed.