SQL Application Server
Required Database Configuration for SQL Server
The default behavior of SQL Server introduces contention in multi-user environments. This is due to the "read locks" that are acquired for all database reads within a transaction. This can lead to unintended blocking, timeouts, and even deadlocks at the BusinessPlus level. To prevent this behavior, it is necessary to enable the READ_COMMITTED_SNAPSHOT feature, available as of SQL Server 2005. For details, refer to the release-specific installation instructions.
Installation Steps
On the Installation Validation screen, enter your installation code and installation key to unlock your products, then select the SQL App Server option.
The installer will not allow the SQL APP Server option to be selected with any other BusinessPlus products, because a BusinessPlus Application install can support multiple accounts at differing release levels. A Web Server install is tied to a single release level.
The Selected Applications screen displays an overview of the products that will be installed. If any Service Packs are needed for Windows or any update to IE is needed, they will be displayed here and will be launched automatically. Generally, a Windows Service Pack or IE update will require a reboot. You will be prompted for this if necessary.
Next, enter configuration settings:
- Two sets of 3rd party software are required for BusinessPlus on SQL to function: Micro Focus Application Server and MKS Toolkit. The 3rd Party Requirements page is displayed when the requirements are not met for one or both of the components. If displayed, the page lists the installed versions that are found and what version is required for this release. If a component is not installed, or is not the correct version for this release, a message of "FAIL" is displayed along with the minimum required version. The installer will not allow you to continue if either of the product requirements is not met. Exit the installer and apply the appropriate software packages, then re-run the BusinessPlus installer.
- When updating a Windows server that contains a BusinessPlus filesystem, the connection name associated with each account is listed in the BusinessPlus Update screen. This is the same name found on the IPC_Daemon service name that is associated with that filesystem. To update an existing install, select the appropriate connection name. To create a new BusinessPlus filesystem on an existing App server, check the "Create NEW filesystem" box.
- Enter configuration variables for the ifas.start.config login script.
- Specify the install path.
- Configure the services for Bathjob and Ilock.
- Add a BusinessPlus user account with local administrative privileges. The installer will default to the account currently configured for BusinessPlus services; if an account is not found, the account IUSR_BP will be used. If a local account is entered and does not exist, the installer will create this account. The configured account is utilized for the service IPC_Daemon in Windows Services on BusinessPlus on SQL installs.
Select the Next button on the Ready to Install screen to begin the installation.
After the installer has completed updating the filesystem, telnet into the updated account to complete the host update steps. See release-specific installation instructions for details.