SQLCLR using the wrong version of the .NET Framework
- by Tobias Rundbom
During a recent restart of our development server the SQL Server started using .NET 4.0 for the SQLCLR. This means that nothing using the CLR in SQL works, or at least that's my understanding by reading these sources:
http://software.intel.com/en-us/blogs/2009/10/16/sql-server-2008-sqlclr-net-framework-version/
www.sqlskills.com/BLOGS/BOBB/post/On-SQL-Server-and-NET-40.aspx
All we get are error messages of this type:
Msg 6517, Level 16, State 1, Line 1
Failed to create AppDomain "xxx.dbo[ddl].3".
Method's type signature is not Interop compatible.
Does anyone know how to solve this or how we can force SQL Server CLR to use an earlier version of the Framework?