This topic contains the hardware and software requirements for running the Aptify 6.4 server components and the Windows Desktop client. It includes the following sections:
...
| Database | Server Operating Systems |
|---|---|
Aptify 6.4 databases deployed and active in: Microsoft SQL Server 2012 Microsoft SQL Server 2014 Microsoft SQL Server 2016 Microsoft SQL Server 2017 (with CLR Security setting disabled) Microsoft SQL Server 2019 The Aptify database supports the following editions for all versions:
| Windows Server 2012 – Foundation, Essentials, Standard, and Datacenter Windows Server 2012 R2 – Foundation, Essentials, Standard, and Datacenter Windows Server 2016 – Foundation, Essentials, Standard, and Datacenter Windows Server 2019 – Foundation, Essentials, Standard, and Datacenter |
...
- Log into SQL Server 2019 with Administrator privileges.
- Right-click the Aptify database and select the 'New Query' option.
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'.
If the value = 1, your 'CLR Strict Security' is enabled.
If the value = 0, your 'CLR Strict Security' is disabled.
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 = 'show advanced options'
If the value = 1, your 'show advance options' is enabled.
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
.
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;
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'.
...