June 17, 2014 at 2:44 pm
HI -
SQL: SQL 2012 Ent.
We have a Severity A case open with Microsoft regarding SQL assemblies and CLR's. Microsoft originally requested we upgrade the .NET framework on the SQL Server to 4.5.1. Unfortunately, Microsoft just informed us (separate SQL engineer from Microsoft) that SQL 2012 will not use the 4.5.1 framework, even if installed and patched. It will always revert to the 4.0 .NET framework.
So - long story short, we installed 4.5.1, and installed the hotfix. I checked the registry \NET Framework Setup\NDP\v4\client and the version is 4.52119. But, when i execute select * from sys.dm_clr_properties the results clearly illustrate v4.0.30319.
I've already rebooted the box several times after the install.
Anyone have any information?
Please let me know.
June 18, 2014 at 4:10 am
When you install a new major release of the .NET framework, the old version stays on there so that applications still expecting the old version don't break. I would imagine, then, that you have both the 4.0 and 4.5 frameworks on the machine now, and since your Microsoft engineer has told you that SQL 2012 can't use the 4.5 framework, it seems entirely expected that the CLR would still be using the 4.0 framework, as your test shows.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply