1

It appears that CLR integration does not like Dotnet framework 2.0 sp2. I am getting the following error message when trying to run code that depends on the clr.

Msg 6510, Level 16, State 11, Line 1
Common Language Runtime (CLR) v2.0.50727 not installed properly. The CLR is required to use SQL/CLR features.

I have verfied with the dotnet verification tool that the dotnet framework for all versions installed work.

I have only found possibly one hint that this is whats causing the issue. I would think thought that if this was the case more people would be screaming. Does anyone have any suggestions on how to track this down better. We have a few systems that are relying on this implementation.

ecathell
  • 113

2 Answers2

1

Restarting the SQL Server service got me past this problem.

The CLR had been enabled using the...

sp_configure 'clr enabled', 1;
GO
reconfigure
GO

...statements but until the SQL Server service was restarted none of the CLR features could be used.

Tom
  • 111
0

It almost sounds like a corrupt install of v2.0.50727. I would try to reinstall that version and the SP. Can you run a custom .net app compiled for that version on that machine?

HunterX3
  • 313
  • 2
  • 6