Failed to initialize the CLR?
mbourgon
Posts: 32 Bronze 2
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.
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.
Comments
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.