Error on Loading Assembly in While Calling CLR Command in SQL Server

Question

I'm receiving an error when trying to run a CLR object from SQL Server:

An error occurred in the Microsoft .NET Framework while trying to load assembly id 65538...

Do I need to enable some SQL Server setting, or is it a bug?

pangular · Accepted Answer · 2018-09-28 12:20:59Z

1

First, you need to enable CLR execution by running this:

EXEC sp_configure 'clr enabled';
EXEC sp_configure 'clr enabled' , '1';
RECONFIGURE;

then change the owner by running this:

USE master
GO
ALTER DATABASE [database_name] SET TRUSTWORTHY ON

USE [database_name]
GO
EXEC sp_changedbowner 'sa'

answered Sep 28, 2018 at 12:20

pangular

7098 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Dan Guzman Over a year ago

Why is TRUSTWORTHY and sa database ownership required in your case? Neither shouldn't typically be needed, even with unsafe assemblies. Module signing is a better practice.

Collectives™ on Stack Overflow

Error on Loading Assembly in While Calling CLR Command in SQL Server

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related