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.

If the restart does not help, try to recreate database structure. Download the registration file and run it, at the end restart Microsoft Outlook.

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.