Product: TIBCO Spotfire®
Error While connecting to MS Sql server - Failed to initialize the Common Language Runtime (CLR)
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)
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