Q. I got the following error during my EP upgrade:

Execution of user code in the .NET Framework is disabled. Enable "clr enabled" configuration option.


A.
For some reason your SQL server has the CLR option disabled.

To enable CLR integration, use the clr enabled option of the sp_configure stored procedure:

  1. Open SQL Server Management Studio.
  2. Click on the "New Query" button.
  3. In the query window paste the following:
    sp_configure 'show advanced options', 1;
    GO
    RECONFIGURE;
    GO
    sp_configure 'clr enabled', 1;
    GO
    RECONFIGURE;
    GO
  4. Now click the "Execute" button (or press F5) to run the stored procedure and change your CLR settings in SQL Server.
  5. In the SQL Server "Messages" window you should see something similar to:
    Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.
    Configuration option 'clr enabled' changed from 0 to 1. Run the RECONFIGURE statement to install.
  6.  That's it!

Article ID: 141, Created On: 2/9/2011, Modified: 11/3/2011