Geeks With Blogs

News


Rodney Vinyard - .NET & SQL Developer When all is said and done, more will be said than done

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

By default .NET Framwork is disabled in SQL2005.

How to fix:

1. Explore "SQL Server 2005/Configuration Tools/Surface Area Configuration" in your Start menu.
2. Select "Surface Area Configuration for Features"
3. You will find "CLR Integration" option, activate it and save.

Posted on Monday, July 17, 2006 6:01 PM | Back to top


Comments on this post: error: Execution of user code in the .NET Framework is disabled. Enable clr enabled configuration option

# re: error: Execution of user code in the .NET Framework is disabled. Enable clr enabled configuration option
Requesting Gravatar...
Thanks for the Information
Left by Ravi on Aug 25, 2006 4:12 AM

# re: error: Execution of user code in the .NET Framework is disabled. Enable clr enabled configuration option
Requesting Gravatar...
Its Very Good
Left by Sreenivasulu on Aug 06, 2007 9:10 PM

# re: error: Execution of user code in the .NET Framework is disabled. Enable clr enabled configuration option
Requesting Gravatar...
thank you very much.
Left by roby on Jan 16, 2008 11:47 AM

# re: error: Execution of user code in the .NET Framework is disabled. Enable clr enabled configuration option
Requesting Gravatar...
thanks for your useful context
Left by saied on Jan 18, 2008 8:18 PM

# re: error: Execution of user code in the .NET Framework is disabled. Enable clr enabled configuration option
Requesting Gravatar...
Thanks. Easy fix
Left by Charlie on Jan 28, 2008 7:52 AM

# re: error: Execution of user code in the .NET Framework is disabled. Enable clr enabled configuration option
Requesting Gravatar...
Thanks...is working
Left by Nothando on May 13, 2008 2:04 AM

# re: error: Execution of user code in the .NET Framework is disabled. Enable clr enabled configuration option
Requesting Gravatar...
I am this issue with SQL Server 2008, any idea how to "enable clr enable" configuration option in 2008?
Left by Ann on Dec 03, 2008 9:01 AM

# re: error: Execution of user code in the .NET Framework is disabled. Enable clr enabled configuration option
Requesting Gravatar...
You can run the following to enable CLR in SQL server 2008.

sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'clr enabled', 1;
GO
RECONFIGURE;
GO
Left by Pratik Shah on Mar 17, 2009 7:08 AM

# re: error: Execution of user code in the .NET Framework is disabled. Enable clr enabled configuration option
Requesting Gravatar...
Thanks. it is very helpfull.
Left by shailesh on Apr 15, 2009 11:41 AM

# re: error: Execution of user code in the .NET Framework is disabled. Enable clr enabled configuration option
Requesting Gravatar...
thanks, it worked. BTW Where is "surface area config" in 2008 express?
Left by Antonio Barroso on May 05, 2009 1:36 PM

# re: error: Execution of user code in the .NET Framework is disabled. Enable clr enabled configuration option
Requesting Gravatar...
very use ful website
Left by prabhu on May 15, 2009 11:50 PM

# re: error: Execution of user code in the .NET Framework is disabled. Enable clr enabled configuration option
Requesting Gravatar...
Thats gr8. Thank u v much.
Left by Zuber on Nov 03, 2009 3:23 AM

# re: error: Execution of user code in the .NET Framework is disabled. Enable clr enabled configuration option
Requesting Gravatar...
very very good
THANKS YOU A LOT FOR THIS
Left by Ivan Fabricio on Nov 14, 2009 10:39 AM

# re: error: Execution of user code in the .NET Framework is disabled. Enable clr enabled configuration option
Requesting Gravatar...
Thank you. It saved my day. :)
Left by Sunil on Dec 14, 2009 6:07 AM

# re: error: Execution of user code in the .NET Framework is disabled. Enable clr enabled configuration option
Requesting Gravatar...
The SQL Server 2005/Configuration Tools/Surface Area Configuration CLR integration setting still works in BIDS/VS 2008 THANKS
Left by peterb on Mar 09, 2010 4:07 PM

# re: error: Execution of user code in the .NET Framework is disabled. Enable clr enabled configuration option
Requesting Gravatar...
it's very helpfull
Left by venkatesh on Apr 13, 2010 4:04 AM

# re: error: Execution of user code in the .NET Framework is disabled. Enable clr enabled configuration option
Requesting Gravatar...
Very good post. It's working now. Thanks...
Left by Ganesh on Jul 21, 2010 2:24 AM

# re: error: Execution of user code in the .NET Framework is disabled. Enable clr enabled configuration option
Requesting Gravatar...
I am still getting the same error after enabling CLR to 1.

Anybody please help me our
Left by Lokesh on Jul 23, 2010 3:32 AM

# re: error: Execution of user code in the .NET Framework is disabled. Enable clr enabled configuration option
Requesting Gravatar...
Hi, I tried to open facets from the instance but it gave me error.. might be some installation error

Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.VisualStudio.Shell.Interop.IUIHostLocale'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{2C2EA031-02BE-11D1-8C85-00C04FC2AA89}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)). (Microsoft.SqlServer.Management.SDK.SqlStudio)


Then I tried Pratik Shah's solution and it worked very well..

Thanks Pratik
Left by Sudip on Jan 04, 2011 12:47 AM

# re: error: Execution of user code in the .NET Framework is disabled. Enable clr enabled configuration option
Requesting Gravatar...
Bakwass, Behuda, Palang tod...
Left by Ravi on Feb 10, 2012 12:43 AM

# re: error: Execution of user code in the .NET Framework is disabled. Enable clr enabled configuration option
Requesting Gravatar...
Thank you so much
Left by Maria on Aug 10, 2012 4:19 AM

# re: error: Execution of user code in the .NET Framework is disabled. Enable clr enabled configuration option
Requesting Gravatar...
You have made some excellent points there. Used to do they’re certified inside subject and barely found any specific info other websites, but great in order to be here, seriously, thanks.
Left by sam on Sep 22, 2012 7:58 PM

# re: error: Execution of user code in the .NET Framework is disabled. Enable clr enabled configuration option
Requesting Gravatar...
thanks it made me smile
Left by sadii on Sep 26, 2012 3:10 AM

# re: error: Execution of user code in the .NET Framework is disabled. Enable clr enabled configuration option
Requesting Gravatar...
Je vous aimais bien... Je suivais votre site depuis plusieurs années... Je vous quitte ce jour.
Left by bhupendra on Feb 25, 2013 3:50 PM

Your comment:
 (will show your gravatar)


Copyright © Rodney Vinyard | Powered by: GeeksWithBlogs.net | Join free