You are currently offline, waiting for your internet to reconnect

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.

CAUSE
This error is generated because the CLR assembly is not enabled during the restore.
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.
MORE INFORMATION
Reporting Reports 64bit 32bit
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.
Properties

Article ID: 2120850 - Last Review: 08/04/2011 18:37:00 - Revision: 2.0

Microsoft Dynamics POS 2009, Microsoft Dynamics POS 2009 Service Pack 1

  • kbmbsmigrate kbsurveynew KB2120850
Feedback
ync=""> var varAutoFirePV = 1; var varClickTracking = 1; var varCustomerTracking = 1; var Route = "76500"; var Ctrl = ""; document.write(" index" class="col-sm-6 col-xs-24 ng-scope"> Paraguay - Español
Venezuela - Español
>id=1&t=">I=4050&did=1&t=">var varClickTracking = 1; var varCustomerTracking = 1; var Route = "76500"; var Ctrl = ""; document.write(" ad="var m=document.createElement('meta');m.name='ms.dqp0';m.content='false';document.getElementsByTagName('head')[0].appendChild(m);" src="http://c1.microsoft.com/c.gif?"> >>