Enable CLR in SQL 2008

 Problem :-

You will find below error in statesys.log when your CLR of SQL is disabed.

*** [42000][6263][Microsoft][ODBC SQL Server Driver][SQL Server]Execution of user code in the .NET Framework is disabled. Enable “clr enabled” configuration option.

Solution :-

First run the below query to check if CLR is enabled. The output should be equal to 1.

SELECT name, value FROMsys.configurationsWHERE name = ‘clr enabled’

If the output is Zero from the above query, then execute the below query to enable CLR.

sp_configure

‘show advanced options’, 1;

GO

RECONFIGURE;

GO

sp_configure

‘clr enabled’, 1;

GO

RECONFIGURE;

GO

Advertisements
This entry was posted in Troubleshooting and tagged . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s