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

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

   

   
   

...

Anchor
_Note_Concerning_SQL _Note_Concerning_SQL

Note Concerning SQL Memory Usage

...

Anchor
_AppServ _AppServ

Application Server Requirements

See Application Server System Requirements for more information on the software and hardware requirements to support an Application Server for executing asynchronous process flow runs and scheduled tasks. An organization can deploy 1 to n application servers, depending on utilization and load.

Anchor
_deskclient _deskclient

Aptify Desktop Client Requirements

...

• 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, 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. 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'.

   

   
   

...

• Operating System: Windows 10, Windows 8.1, Windows 8 (Professional, Ultimate or Enterprise Editions)
• Aptify 6.0 3 Desktop client
• 32-bit version of the Crystal Reports 13 viewer (Aptify can provide the installer for this software)
• SSRS Installer
• Microsoft .NET Framework v4.8: NET Framework 4.8 is not installed by Aptify. If not already installed on the computer, you can download the installer here: https://dotnet.microsoft.com/download/dotnet-framework
• Microsoft DHTML Editing Control: This control is required to use HTML fields in the Aptify desktop client. You can download the control here: https://www.microsoft.com/en-us/download/details.aspx?id=8956.
• Microsoft Office 2007 or later: 
  
  • This includes Office 365 if you are using it in conjunction with the desktop version of Microsoft Office (2007, 2010, or 2013) or if you have Office Professional Plus with Office 365.
  • Microsoft Office is only required if an organization intends to use any of Aptify’s Microsoft Office integration features, such as the Export to Excel wizard, the Microsoft Word Mail Merge wizard, Pivot Table views, and Outlook integration.
  • Note that Aptify’s Pivot Table view type requires the Office Web Components that are included with Office 2003 (OWC 11). You need to download and install OWC 11 separately to enable pivot table sup­port. OWC 11 is available for download at: http://www.microsoft.com/downloads/details.aspx?Fami-lyId=7287252C-402E-4F72-97A5-E0FD290D4B76&displaylang=enOWC 11 separately to enable pivot table sup­port.
    
    

    Anchor
    #_dchw #_dchw

    Hardware Requirements

...

• Operating System: Windows 8, Windows 8.1 or Windows 10
• Microsoft SQL Server 2012 or later
• Aptify 6.3 Server components and the Windows Desktop client
• 32-bit version of the Crystal Reports 13 viewer (Aptify can provide the installer for this software)
• Microsoft .NET Framework v4.8 : NET Framework 4.8 is not installed by Aptify. If not already installed on the computer, you can download the installer here: https://dotnet.microsoft.com/download/dotnet-framework
• Microsoft DHTML Editing Control: This control is required to use HTML fields in the Aptify desktop client. You can download the control here: https://www.microsoft.com/en-us/download/details.aspx?id=8956.
• Microsoft Office 2007 or later: 
  
  • This includes Office 365 if you are using it in conjunction with the desktop version of Microsoft Office (2007, 2010, or 2013) or if you have Office Professional Plus with Office 365.
  • Microsoft Office is only required if an organization intends to use any of Aptify’s Microsoft Office integration features, such as the Export to Excel wizard, the Microsoft Word Mail Merge wizard, Pivot Table views, and Outlook integration. 
  • Note that Aptify’s Pivot Table view type requires the Office Web Components that are included with Office 2003 (OWC 11). You need to download and install OWC 11 separately to enable pivot table sup­port. OWC 11 is available for download at: http://www.microsoft.com/downloads/details.aspx?Fami-lyId=7287252C-402E-4F72-97A5-E0FD290D4B76&displaylang=en.
    
  Microsoft MapPoint for Map Views support in Aptify Windows desktop application
  • 
    
    
• Microsoft Report Viewer 2012 to support viewing of Microsoft SQL Server Reporting Services (SSRS) reports

...