1

Error in Adding CLR assembly of .net framework 5.0 in SQL Server 2019.

I have a DLL which uses .NET Framework v5.0. and I want to add it to SQL Server 2019 using CREATE ASSEMBLY.

Is it possible to to add .NET Framework 5.0 and .net core 3.1 Assembly to SQL Server 2019?

Actually when I tried it gives the following error.

Assembly 'EncryptionDecryptionApp' references assembly 'system.runtime, version=4.2.1.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a.', which is not present in the current database. SQL Server attempted to locate and automatically load the referenced assembly from the same location where referring assembly came from, but that operation has failed (reason: 2(The system cannot find the file specified.)). Please load the referenced assembly into the current database and retry your request.

enter image description here

I tried following code to remove it. But it didn't work for me.

 ALTER DATABASE [Taasks] SET TRUSTWORTHY ON;
 go
 sp_configure 'clr enabled', 1;
 RECONFIGURE;
    
    
 CREATE ASSEMBLY [abc] AUTHORIZATION [dbo]
 FROM 'C:\Dlls\EncryptionDecryptionApp.dll'
 WITH PERMISSION_SET = EXTERNAL_ACCESS
Improve this question
3
  • 2
    stackoverflow.com/questions/63078800/… - basically, I think the answer is "no" for now (and presumably, forever, as far as SQL 2019 goes) Commented Oct 18, 2021 at 15:08
  • Please tell me the reason. Commented Oct 18, 2021 at 15:12
  • 2
    because it hasn't yet had at least some of the following: scoping, feasibility/impact analysis, approval/budgeting, design, implementation, testing (including performance, security, stability, etc), documentation (including translation), support - and therefore: does not currently work Commented Oct 18, 2021 at 15:22
Related questions
2
Is it possible to to add .NET Framework v.2.0 Assembly to SQL Server 2012?
0
how to add a assembly from .net framework in the new csproj based dotnet core class libraries
5
Can a class library be shared between .NET Core 2.0 and SQL Server CLR?
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.