Question

Rama Subba Reddy on Tue, 13 May 2014 09:41:39


Hi Techies,

I want to use .NET 4.0 class library(i.e. I'm using especially few new futures of 4.0 ) in SQL SERVER 2008 R2. But when ever i try to register assembly in SQLSERVER , getting below error

CREATE ASSEMBLY CLRSUMVarBinary FROM 'C:\CLRDefine\CLRUserDefined.dll';

CREATE ASSEMBLY for assembly 'CLRUserDefined' failed because assembly 'CLRUserDefined' failed verification. Check if the referenced assemblies are up-to-date and trusted (for external_access or unsafe) to execute in the database. CLR Verifier error messages if any will follow this message

I gone through few article, it was mentioned directly .NET 4.0 CLR can not support in SQL SERVER 2008 R2.But,

Is there any way to force SQL SERVER 2008 R2 to use CLR 4.0 ? i.e. any configuration changes ?

Regards,

Rama


Sponsored



Replies

Vaibhav Chaudhari on Tue, 13 May 2014 09:56:18


You have posted this question under T-SQL forum.

Suggest you to post it to SQL Server --> .NET Frameowrk Inside SQL Server

Erland Sommarskog on Tue, 13 May 2014 11:16:48


Is there any way to force SQL SERVER 2008 R2 to use CLR 4.0 ? i.e. any configuration changes ?

No. If you want to use CLR 4.0 features in SQL Server, you need to use SQL 2012 or later.

Elvis Long on Wed, 14 May 2014 05:44:45


Hi Rama,

SQL Server 2012 loads version .NET 4.0 of the CLR. Here is a good article for your reference, please see:
SQL Server 2012 - SQLCLR .NET Framework Version: http://blogs.msdn.com/b/dohollan/archive/2012/04/20/sql-server-2012-sqlclr-net-framework-version.aspx

If you have any feedback on our support, please click here.

Regards,