You are here: Home / FAQ / Database / Execution of user code in the .NET Framework is disabled. Enable "clr enabled" configuration option

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

Description

The error may appear both on local and server SQL database of eWay-CRM. The application log contains this message:

System.Data.SqlClient.SqlException: Execution of user code in the .NET Framework is disabled. Enable "clr enabled" configuration option.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

The error is related to one of the eWay-CRM CLR procedures.

Version

All versions of eWay-CRM

Difficulty

High

Resolution

Option 1 - Local PCs

Restart your PC.

Option 2 - Server

  1. Launch Microsoft SQL Server Management Studio - you can download it here.
  2. Run this SQL script whereas the path in the parameter is the path to the eWay-CRM web service folder (you have to run procedure as system administrator):
    EXEC [dbo].[eWaySP_CreateClrProcedures] @WebServicePath = N'C:\inetpub\wwwroot\eWay\'
  3. Now, eWay-CRM synchronization should be proceeded successfully.