Updating SQL Server CLR Strict Security - PAS Dashboard - 3.6 - Help - Intergraph

PAS Dashboard for PSI and Integrity User Guide

Language
English
Product
PAS Dashboard
Subproduct
PSI
Search by Category
Help
Dashboard Version
3.6

Starting with SQL Server 2017, the clr strict security advanced setting is enabled by default. For more information, see Microsoft SQL Server documentation.

To successfully install or upgrade PAS Dashboard on SQL Server 2017 or later, disable clr strict security. After installing PAS Dashboard, you can enable clr strict security if it is required for your environment.

To disable or enable CLR strict security:

  1. Open Microsoft SQL Server Management Studio.

  2. Connect to the SQL Server.

  3. Run the following commands to disable clr strict security:

    EXEC sp_configure 'show advanced options', 1;
    RECONFIGURE;
    EXEC sp_configure 'clr strict security', 0;
    RECONFIGURE;
    EXEC sp_configure 'show advanced options', 0;
    RECONFIGURE;

  4. After you install or upgrade PAS Dashboard, enable clr strict security, if desired, by running the following commands:

EXEC sp_configure 'show advanced options', 1;
RECONFIGURE;
EXEC sp_configure 'clr strict security', 1;
RECONFIGURE;
EXEC sp_configure 'show advanced options', 0;
RECONFIGURE;