Aptify strongly recommends that you install and test the installation on a test environment first using a copy of your production server before running it directly on the production server. Also, review the Important Pre-Installation Considerations topic before starting an installation. |
Download the Aptify 5.5.4 Service Pack Installer ZIP file to a folder on the database server and unzip its contents.
When using low-end hardware, Aptify recommends running the installation program locally on the database server; do not run it over the network. |
The Windows API requires that fully qualified file names are less than 260 characters. Aptify recommends that the Aptify 5.5.4 Service Pack Installer ZIP file is unzipped in a folder close to the drive's root folder (for example C:\Downloads) in order to limit the possibility of exceeding the character limitation for fully qualified file names imposed by the operating system. |
Enter login information for your database server. Specify an account with system administrator privileges to both the Aptify database and SQL Server. The user should also be tied to a Developer license to ensure that the setup can perform such tasks as entity creation when needed.
Selecting the System Administrator option when creating a user in the Aptify database sets the user to a dbowner in SQL Server. It does not add the user to the sysadmin role. You will need to manually add the user to the sysadmin role through SQL Server. If in doubt, check the user's permissions in the Security > Logins area of SQL Management Studio before proceeding with the installation. |
If you are using the SQL Server Reporting System (SRSS) in your environment, enter the location where the SSRS reports are stored in the SSRS Reports Path field.
The location should be entered in the following format:
You can leave this field blank if an SQL Reporting Server is not already configured or if you are not planning on using SSRS in your environment. The location can be configured at a later time. |
If you have organization specific configurations, you can check any or all of the options on the Validation step to help identify invalid repository and database objects, and foreign key constraint errors.
Aptify recommends that you check all validation options to ensure Aptify 5.5.4 installs successfully. |
If you are planning on viewing reports using SQL Server Reporting Services (SSRS), you will need to install 32-bit version of the Microsoft SQL Server System CLR Types and Report Viewer.
Save and close the Entities record.
Regenerate the base view for any related entities that join to the entity for which you just enabled row set security.