Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Error message after you restore a SQL Server 2008 32-Bit Dynamics POS 2009 database to a SQL Server 2008 64-Bit instance and try to run any report: "Execution of user code in the .NET Framework is disabled. Enable "clr enabled" configura...

Error message after you restore a SQL Server 2008 32-Bit Dynamics POS 2009 database to a SQL Server 2008 64-Bit instance and try to run any report: "Execution of user code in the .NET Framework is disabled. Enable "clr enabled" configura...

Symptoms

You receive the following error message after you restore a SQL Server 2008 32-Bit Microsoft Dynamics POS 2009 database to a SQL Server 2008 64-Bit instance and try to run any report:

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

↑ Back to the top

Cause

This error is generated because the CLR assembly is not enabled during the restore.

↑ Back to the top

Resolution

To enable the CLR assembly, follow these steps:
  1. Open SQL Server Management Studio.
  2. Connect to the POS 2009 instance you are using.
  3. Right click on the database and click New Query.
  4. Paste the following SQL statement into the New Query window:and run the following script:
    EXEC sp_configure 'clr enabled', 1;  RECONFIGURE WITH OVERRIDE;
  5. Press F5 to run the SQL Statement.

↑ Back to the top

Keywords: kbmbsmigrate, kbmbspartner, kbsurveynew, kb

↑ Back to the top

Article Info
Article ID : 2120850
Revision : 1
Created on : 1/7/2017
Published on : 8/4/2011
Exists online : False
Views : 142