Enabling CLR still doesn't allow me to run code on sql server

Question

I'm using the following command to try and enable the CLR on a SQL Server 2008 instance

EXEC sp_configure 'clr enabled', 1
GO

RECONFIGURE
GO

But I still get the following error

Execution of .NET Framework code is disabled. Set "clr enabled" configuration option and restart the server

Do I need to do anything else?

Then you are doing something incorrect. That's all there is to it. — Remus Rusanu
– Remus Rusanu, Commented Feb 2, 2016 at 13:40
It's trying to do this when it fails:- CREATE ASSEMBLY [FileObject] — Shazoo
– Shazoo, Commented Feb 2, 2016 at 13:47

Community · Accepted Answer · 2020-06-20 09:12:55Z

5

To review what has been checked and attempted so far:

EXEC sp_configure 'clr enabled', 1; has been executed.
RECONFIGURE; has been executed.
The server has been restarted. This should only be necessary on WOW64 servers.
Running EXEC sp_configure 'clr enabled'; shows a 1 for run_value.
Running EXEC sp_configure 'lightweight pooling'; shows a 0 for run_value.
state property in sys.dm_clr_properties has a value of "Locked CLR version with mscoree", meaning:

The Locked CLR version with mscoree state may be seen where the hosted CLR is not being used and, thus, it has not yet been initialized. The hosted CLR is initialized the first time a DDL statement (such as CREATE ASSEMBLY (Transact-SQL)) or a managed database object is executed.

Additional things to try / check:

Make sure that .NET Framework 2.0 and 3.5 SP1 are installed
Make sure that .NET Framework patches have been applied through Windows Update
Possibly make sure, in Control Panel\Programs\Programs and Features that "Microsoft SQL Server System CLR Types" is installed
Check your authentication type. If set to "both", try change to "Windows Only", restarting the SQL Server service, and see if that helps. Not a good long-term solution, but might point in a direction.
What account is the MSSQLSERVER service logging on as? There are some reports that "Network Service" or "NT AUTHORITY\Network Service" might have issues and that Local System account might be preferred.
??

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Feb 2, 2016 at 20:24

Solomon Rutzky

49.3k11 gold badges141 silver badges184 bronze badges

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

3 Comments

Shazoo Over a year ago

I'm giving up on this. It's not essential for this server and it's taking up too much of my time. Thanks for your help anyway

Kevin Pope Over a year ago

Installing .Net 2.0 and 3.5 resolved this for me - thanks!

Solomon Rutzky Over a year ago

@KevinPope Glad this info help! Thanks for posting what worked for you to help narrow down for others :-)

vborutenko · Accepted Answer · 2016-02-02 13:34:21Z

1

Try

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

Also

To enable CLR integration, you must have ALTER SETTINGS server level permission, which is implicitly held by members of the sysadmin and serveradmin fixed server roles.

edited Feb 2, 2016 at 13:34

answered Feb 2, 2016 at 13:30

vborutenko

4,4535 gold badges32 silver badges50 bronze badges

Comments

Jakub Szumiato · Accepted Answer · 2016-02-02 13:54:16Z

0

Are you sure you have advanced options enabled?

sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'clr enabled', 1;
GO
RECONFIGURE;
GO

edited Feb 2, 2016 at 13:54

answered Feb 2, 2016 at 13:50

Jakub Szumiato

1,3181 gold badge14 silver badges19 bronze badges

5 Comments

Shazoo Over a year ago

Yes, I have advanced options enabled

Jakub Szumiato Over a year ago

What is your assembly .NET CLR version? Is it the same as in results of: select * from sys.dm_clr_properties

Solomon Rutzky Over a year ago

CLR enabled is not an advanced option.

Jakub Szumiato Over a year ago

I just got some old code of mine and it was there. I checked now and on MSDN it's also described like that: msdn.microsoft.com/pl-pl/library/ms131048(v=sql.100).aspx. Finall I also double checked now and I can execute it without advanced options enabling, which prooves you're right it's not needed.

Jakub Szumiato Over a year ago

Another question is, what account is it running on? If it's a network service, maybe you could try changing it to 'Local System' for a moment and see if it's the same

Collectives™ on Stack Overflow

Enabling CLR still doesn't allow me to run code on sql server

3 Answers 3

3 Comments

Comments

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related