Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SSRS 2012 Custom Code .NET Framework 4.0 not supported

I was very hopeful that since SQL Server 2012 SQLCLR supports .NET 4.0 that SQL Server Reporting Services (SSRS) 2012 would support .NET 4.0 custom code assemblies. When attempting to upload an rdl (via the Report Manager or via RSBuild) that references .NET 4.0 assemblies, the Reports Manager throws an error stating

This assembly is built by a runtime newer than the currently loaded runtime and cannot be loaded. (rsErrorLoadingCodeModule)

Is there something I can configure to get SSRS 2012 to load .NET 4.0 assemblies? Will we be waiting until the next major release of SQL Server before we see .NET 4.0 support for custom assemblies in SSRS?

like image 276
Adam Caviness Avatar asked Jun 01 '12 13:06

Adam Caviness


1 Answers

SSRS 2014 is now released and custom code still does not support the .Net 4.0 Framework.

See prerequisites in the "Hardware and Software Requirements for Installing SQL Server 2014" (http://msdn.microsoft.com/en-us/library/ms143506(v=sql.120).aspx)

It's very amusing that SQL Server 2014 has just RTM'ed a few days ago and is already considered a "legacy application" by the .Net Framework guys who say:

.NET Framework 3.5 is not included by default in Windows 8 or Windows Server 2012, but you can download and deploy it for legacy application compatibility.

... see "Microsoft .NET Framework 3.5 Deployment Considerations" (http://technet.microsoft.com/en-us/library/dn482066.aspx)

I think the bigger issue is whether the support lifecycle of .Net 3.5 SP1 can actually be tied to the OS'es for which it was a default component. Whatever they say, I can't see Microsoft quitting support on .Net 3.5 as long as SQL Server continues making it a prerequisite in a product they are releasing today. The .Net Framework guys can't be too happy with the lazy SQL guys right now...

like image 198
David Beavon Avatar answered Oct 12 '22 08:10

David Beavon