ASP.NET CLR Not Enabled

Question

I am getting the following error on my new installation of ASP.Net and SQL Server when I run my app:

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

I have tried to fix it by running this:

 use dasolPSDev;

 sp_configure 'clr enabled', 1
 go
 RECONFIGURE
 go
 sp_configure 'clr enabled'
 go

But then I get:

 Msg 102, Level 15, State 1, Line 3
 Incorrect syntax near 'sp_config

From Microsoft: support.microsoft.com/en-us/help/2120850/… — Darren Griffith
– Darren Griffith, Commented Nov 21, 2019 at 21:11

Amit · Accepted Answer · 2011-05-26 22:17:04Z

143

Try this

use dasolPSDev;

EXEC sp_configure 'clr enabled', 1
 go
 RECONFIGURE
 go
EXEC sp_configure 'clr enabled'
 go

answered May 26, 2011 at 22:17

Amit

22.2k28 gold badges76 silver badges94 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

mithilatw Over a year ago

How long does this script normally take to execute? because mine, I have had it run more than 1 minute and still no result..!!

ganesh Over a year ago

How to run this

Jon Schneider · Accepted Answer · 2014-11-11 18:59:31Z

30

Simplified version of jams' solution which worked for me (SQL Server 2012):

sp_configure 'clr enabled', 1
GO
RECONFIGURE
GO

Source: http://msdn.microsoft.com/en-us/library/ms254506%28v=vs.80%29.aspx

edited Nov 11, 2014 at 18:59

answered Nov 11, 2014 at 16:43

Jon Schneider

27.2k25 gold badges158 silver badges183 bronze badges

Comments

hong4rc · Accepted Answer · 2018-11-09 17:17:35Z

3

I had a similar issue, but this works for me (SQL Server 2008 R2):

sp_configure 'clr enabled', 1
GO

RECONFIGURE
GO

edited Nov 9, 2018 at 17:17

hong4rc

4,0994 gold badges24 silver badges42 bronze badges

answered Nov 9, 2018 at 16:22

Theodore Ametepey

311 bronze badge

Comments

datchung · Accepted Answer · 2024-03-25 20:35:57Z

1

The following steps fixed my problem.

Open SQL Server Management Studio.
Connect to your database instance.
File > New > Query with Current Connection.
Paste the following into the editor (reference: https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/clr-enabled-server-configuration-option?view=sql-server-ver16).

EXEC sp_configure 'clr enabled';  
EXEC sp_configure 'clr enabled' , '1';  
RECONFIGURE;

Click Execute.

answered Mar 25, 2024 at 20:35

datchung

4,7261 gold badge37 silver badges32 bronze badges

Comments

user7205049 · Accepted Answer · 2016-11-24 11:54:14Z

0

I tried with sp_configure @configname=clr_enabled, @configvalue=1

then restarted the sql server. it worked

answered Nov 24, 2016 at 11:54

user7205049

1

Collectives™ on Stack Overflow

ASP.NET CLR Not Enabled

5 Answers 5

2 Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

2 Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related