Problem:


During installation process of EzParts, the following error message appears: "System.Data.SqlClient.SqlError: Execution of .NET Framework code is disabled. Set "clr enabled" configuration option."


Solution:


To solve the issue, the CLR configuration option must be enabled. Follow the steps below to run the query to enable it:


1. Start SQL Server Management Studio Express (go to the Start menu -> Programs -> MS SQL Server 2005 -> SQL Server Management Studio Express).

If it is not installed, see the steps below:

a) Insert the first EzParts disk into the DVD-ROM drive.

b) Open the soft folder on the disk.

c) Double click the SQL Server 2005 Management Studio Express.msi file to install Microsoft SQL Server Management Studio Express.

2. On the Connect to Server window select Server Name\Instance Name from the Server name drop-down list.

3. Select Windows Authentication mode from the Authentication drop-down list and click Connect.

4. Right click the required database and select New Query from the context menu. The new query window will be opened.

5. Enter the following query and Run it by pressing F5:


      EXEC sp_configure 'show advanced options', 1

      RECONFIGURE

      EXEC sp_configure 'clr enabled', 1;

      RECONFIGURE WITH OVERRIDE;