Hi frends,
Does the 'chapter 6.2 CLR Assembly Permission Set' of 'CIS_Microsoft_SQL_Server_2016_Benchmark_v1.3.0.pdf' SQL Server Hardening affect Dynamics CRM functionality?
How to deal with the 'MSCRMSqlClr' assembly is 'UNSAFE_ACCESS' in the sql server?
Has anyone ever done this?
It is my pleasure if you give any suggestion, thanks in advance guys.
Cause:
the SQL Server hardening is necessary, so when i follow the pdf to run the sql srcipt it return /MSCRMSqlClr UNSAFE_ACCESS/,
| Run | Returned |
USE [CRM_Database_of_org_01];
GO
SELECT name,
permission_set_desc
FROM sys.assemblies
WHERE is_user_defined = 1; | MSCRMSqlClr UNSAFE_ACCESS |
i am afread that i have to follow the chapter 6.2 of the 'CIS_Microsoft_SQL_Server_2016_Benchmark_v1.3.0.pdf' to run another sql script to alter the 'permission_set' to 'SAFE' of the 'MSCRMSqlClr' assembly.
below is the screenshot of the chapter 6.2 of the 'CIS_Microsoft_SQL_Server_2016_Benchmark_v1.3.0.pdf':
