After removing and reinstalling SQL Server and attaching the CRM database, when trying to load any spec, users may get the following error:
Unable to load catalog item.
In SQL Server, the user should enable CLR Integration.
1. Open SQL Server. 2. After connecting to a database, in Object Explorer, right click the server and then click Facets. 3. In the Facet field, click the drop-down arrow and select Surface Area Configuration. 4. Under Facet Properties, click ClrIntegrationEnabled. 5. In the drop-down box beside ClrIntegrationEnabled, select True. 6. Click OK.