Failed to initialize the CLR?

I'm getting the following messages trying to run comparisons on some (though not all) servers. Additionally, all have "clr enabled" = 0 in sp_config.

X Registering data sources
servername.databasename-Reading assemblies

Failed to initialize the Common Language Runtime (CLR) v2.0.50727 with HRESULT 0x80131522. You need to restart SQL Server to use CLR integration features.

This was on a 2008R2 SP2 server; other 2008 SP2 servers, also with clr disabled, don'[t have this problem.

Is there a way to get this to work? It's exceedingly frustrating.

mbourgon March 23, 2015 12:08

Comments

1 comment

Seems like it's a server issue.

http://stackoverflow.com/questions/7525 ... -hresult-0

or possibly
https://support.microsoft.com/en-us/kb/2003681/en-us

Looks like I need to restart the SQL Service, but I also read: "The problem is caused by updating the .NET Framework (to say, Service Pack 2) after SQL Server is installed. Repairing the .NET Framework restores the functionality."

FYI.

mbourgon March 23, 2015 15:28

0

Add comment

Please sign in to leave a comment.

How can we help you today?

Failed to initialize the CLR?

Comments

Add comment