CLR permission
-- Enabling CLR Integration
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'clr enabled', 1;
GO
RECONFIGURE;
GO
-- clr strict security Issue in SQL Server 2017
EXEC sp_configure 'show advanced options',1 ;
GO
RECONFIGURE;
GO
EXEC sp_configure 'clr strict security',0 ;
GO
RECONFIGURE;
GO
ALTER DATABASE DatabaseName SET TRUSTWORTHY ON ;
GO
Comments
Post a Comment