How to disable "clr strict security" in SQL Server

Question

I enabled clr integration (i.e. SQLCLR) by running:

EXEC sp_configure 'clr enabled', 1;  
RECONFIGURE;

Now when I try:

EXEC sp_configure 'clr strict security', 0;
RECONFIGURE;

I get an error saying the setting does not exist:

Msg 15123, Level 16, State 1, Procedure sp_configure, Line 62

The configuration option 'clr strict security' does not exist, or it may be an advanced option.

I know the proper solution to my problem is signing the assembly containing the stored procedures to allow it running with strict security but for now I need the quick and dirty fix.

"15.02070"? The latest version is 15.0.4013.40. We're not even on version 15.1 yet, let alone 15.2070. — Thom A
– Thom A ♦, Commented Feb 25, 2020 at 13:48
Hello jakubiszon. Can you please update the question with the exact error number (i.e. the "Msg XXXX ...") and maybe also the error text? When posting about errors in general, it's always best to include an error message or code given that there are so many different errors. This helps people find the answer to their particular error faster. And in this case, without the error info, you've really just duplicated the official documentation which states that this is an advanced option. Thanks :-) — Solomon Rutzky
– Solomon Rutzky, Commented Feb 25, 2020 at 15:47

jakubiszon · Accepted Answer · 2020-02-25 16:59:40Z

61

Enabling advanced options resolved my problem:

EXEC sp_configure 'show advanced options', 1;
RECONFIGURE;

EXEC sp_configure 'clr strict security', 0;
RECONFIGURE;

Now I can create assemblies.

edited Feb 25, 2020 at 16:59

answered Feb 25, 2020 at 13:37

jakubiszon

3,5831 gold badge33 silver badges44 bronze badges

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

5 Comments

Solomon Rutzky Over a year ago

Hi there. Just FYI: the first 2 statements (i.e. enabling "clr enabled") really has nothing to do with disabling "clr strict security", so should probably be removed. Thanks.

jakubiszon Over a year ago

the second one makes the third one possible to run without throwing an exception

Solomon Rutzky Over a year ago

Sorry if I was unclear. I was being a bit literal in that the first two statements are the first EXEC and the first RECONFIGURE.

Red Over a year ago

Worked for me on my sql14 instance, but for sql 19+ is no longer necessary

mkabhishek Over a year ago

worked for SQL Server 15.0

Collectives™ on Stack Overflow

How to disable "clr strict security" in SQL Server

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related