Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

ASP.NET CLR Not Enabled

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 
like image 715
cdub Avatar asked May 26 '11 22:05

cdub


People also ask

How do you check if CLR is enabled or not?

To determine if CLR is enabled, execute the following commands: EXEC SP_CONFIGURE 'show advanced options', '1'; RECONFIGURE WITH OVERRIDE; EXEC SP_CONFIGURE 'clr enabled';

How do I enable OLE automation procedures?

By default, SQL Server blocks access to OLE Automation stored procedures because this component is turned off as part of the security configuration for this server. A system administrator can enable access to OLE Automation procedures by using sp_configure.


1 Answers

Try this

use dasolPSDev;  EXEC sp_configure 'clr enabled', 1  go  RECONFIGURE  go EXEC sp_configure 'clr enabled'  go 
like image 97
jams Avatar answered Oct 16 '22 21:10

jams