Enable CLR for SQL

By | November 14, 2012

Are you getting the below mentioned errors while executing user defined components on SQL?
1. Exceptions like ‘Message=Execution of .NET Framework code is disabled. Set “clr enabled” configuration option and restart the server.
 
2. Execution of user code in the .NET Framework is disabled. Enable “clr enabled” Enable “clr enabled” configuration option
These errors basically occur because the CLR is disabled. To enable CLR you need to execute a query in the query analyzer. It is important that, you need to be connected to the database that needs CLR to be enabled. The query to enable the CLR is as follows:
 
sp_configure ‘show advanced options’, 1;
GO
RECONFIGURE;
GO
sp_configure ‘clr enabled’, 1;
GO
RECONFIGURE;
GO