Page Comparison

...

1. Log into SQL Server 2017 with Administrator privileges.
2. Right-click the Aptify database and select the 'New Query' option.

3. To confirm that the 'CLR Strict Security' is enabled, run the given query.

   Info
   select name,value from sys.configurations where name = 'clr strict security'.

   1. If the value=1, your 'CLR Strict Security' is enabled.

   2. If the value=0, your 'CLR Strict Security' is disabled.

4. To disable the 'CLR Strict Security' (value = 0) include the given query and execute it.

   Info
   sp_configure 'clr strict security', 0 RECONFIGURE   USE APTIFY ALTER DATABASE CURRENT SET TRUSTWORTHY ON; ALTER DATABASE CURRENT SET TRUSTWORTHY OFF;

5. Execute the below query to make sure that the 'CLR Strict Security' is disabled (value = 0).

   Info
   select name,value from sys.configurations where name = 'clr strict security'.

   

    

    

Anchor
_minhwdb _minhwdb

Minimum Hardware Requirements - Database Server

...