Page Comparison

This topic contains the hardware and software requirements for running the Aptify 6.3 server components and the Windows Desktop client. It includes the following sections: 

...

• Supported Database and Operating Systems
• Requirements to Use Microsoft SQL Server 2017
• Minimum Hardware Requirements - Database Server
• Mid-Point Hardware Requirements - Database Server
• High-End Hardware Requirements - Database Server

...

1. Log into SQL Server 2019 with Administrator privileges.
2. Right-click the Aptify database and select the 'New Query' option.To confirm that the 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

   enabled,

   1. disabled.

4. Enable ‘show advance options’ to proceed further. To confirm the value of ‘show advance options’ run the given query.

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

   1. If the value = 1, your 'CLR Strict Securityshow advance options' is enabled.If the value = 0, your 'CLR Strict Security' is disabled..

   2. If the value = 0, your 'show advance options ' is disabled.

      • Enable ‘show advance options’ by executing given procedure.

        Info
        EXEC sp_configure 'show advanced options', 1 RECONFIGURE

        
        

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

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

   
   

6. 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
_Note_Concerning_SQL _Note_Concerning_SQL

Note Concerning SQL Memory Usage

...

• Supported Database and Operating Systems
• Requirements to Use Microsoft SQL Server 2017
• Minimum Hardware Requirements - Database Server
• Mid-Point Hardware Requirements - Database Server
• High-End Hardware Requirements - Database Server

...

1. Log into SQL Server 2019 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

   'New Query' option.To confirm that the

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

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

   enabled,

   1. disabled.

4. Enable ‘show advance options’ to proceed further. To confirm the value of ‘show advance options’ run the given query.

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

   1. If the value = 1, your 'CLR Strict Securityshow advance options' is enabled.

   2. If the value = 0, your 'CLR Strict Securityshow advance options ' is disabled.

      • Enable ‘show advance options’ by executing given procedure.

        Info
        EXEC sp_configure 'show advanced options', 1 RECONFIGURE

        
        

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

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

   
   

6. 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'.

   

   
   

...