Anveo Knowledge Base

Frequently Asked Questions / Anveo Web Portal / Strict Security is blocking Delta Server

Strict Security is blocking Delta Server

Updated

If you run into the Error “…failed because ‘clr strict security’…” after installing the SQL Server you need to deactivate the strict Security.

To do that execute the following SQL script on your SQL server:

-- to disable
EXEC sys.sp_configure N'show advanced options', N'1';
RECONFIGURE WITH OVERRIDE;
EXEC sys.sp_configure N'clr strict security', N'0';
RECONFIGURE WITH OVERRIDE;
EXEC sys.sp_configure N'show advanced options', N'0';
RECONFIGURE WITH OVERRIDE;
GO