Error While connecting to MS Sql server - Failed to initialize the Common Language Runtime (CLR)
Article ID: KB0075879
Updated On:
| Products | Versions |
|---|---|
| Spotfire Server | All Versions |
Description
Error while connecting to MS SQL Server Datasource via the Information Designer
===============
Error message: Could not get contents of "Datasource" from the server.
The data source reported a failure.
InformationModelException at Spotfire.Dxp.Data:
Error retrieving metadata: Failed to initialize the Common Language Runtime (CLR) v2.0.50727 due to memory pressure. This is probably due to memory pressure in the MemToLeave region of memory. For more information, see the CLR integration documentation in SQL Server Books Online. (HRESULT: 80131500)
===============
Resolution
This is generally caused if using 32bit SQL Server. SQL server 32 bit instance's virtual memory is limited to only 4GB
You can check the bitness by running 'select @@version', refer the below url for more information
https://www.mssqltips.com/sqlservertip/1140/how-to-tell-what-sql-server-version-you-are-running/
You can check the bitness by running 'select @@version', refer the below url for more information
https://www.mssqltips.com/sqlservertip/1140/how-to-tell-what-sql-server-version-you-are-running/
Issue/Introduction
Error While connecting to MS Sql server - Failed to initialize the Common Language Runtime (CLR)
Additional Information
https://support.microsoft.com/en-us/help/2003681/possible-causes-of-failed-to-initialize-the-common-language-runtime-cl
https://support.microsoft.com/en-us/help/969962/various-memory-errors-are-logged-to-sql-server-error-log-when-using-sq
https://support.microsoft.com/en-us/help/969962/various-memory-errors-are-logged-to-sql-server-error-log-when-using-sq
Feedback
Yes
No
Powered by
