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
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';
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.
Try this
use dasolPSDev; EXEC sp_configure 'clr enabled', 1 go RECONFIGURE go EXEC sp_configure 'clr enabled' go
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With