Installation Wizard doesn't detect SQL Server and database components on upgrade

Products

• Information Centric Analytics

Issue/Introduction

When attempting to upgrade Information Centric Analytics (ICA), the following warning messages are displayed in the Symantec ICA Installation Wizard on the Website page:

Must have SQL Server 2016 SP1 CU5 or higher
Must have SQL Server Enterprise Edition
SQL Server service must be started
SQL Server service must be started
Must have SQL Server 2016 SP1 CU5 or higher
Must have SQL Server Enterprise Edition
The Risk Fabric database should already exist but does not. Either restore the Risk Fabric database, or finish deleting this installation and start again.
SSAS Server service must be started.
SSAS Server must be accessible to account running installer and service account.
SSAS Server service must be started
The Risk Fabric SSAS database should already exist but does not. Either restore the Risk Fabric SSAS database, or finish deleting this installation and start again.
SSAS Server must be accessible to account running installer and service account.

Environment

Release : 6.x

Cause

The installation wizard detects there is an extant ICA installation reference in Microsoft Internet Information Services (IIS) but can't access the database connection string stored in the site's configuration file. This can be caused by any of the following conditions:

1. The Risk Fabric Server Web folder has been renamed, moved, or deleted
2. The file web.config has been renamed, moved, or deleted
3. The account under which the installation wizard is running does not have access to the Risk Fabric Server Web folder

Resolution

To resolve this error, ensure the Risk Fabric Server Web folder has not been renamed, moved, or deleted from the path specified in IIS for the site. To lookup this path, follow this procedure:

1. Open Internet Information Services (IIS) Manager
2. In the Connections pane, navigate to <server name> > Sites
3. Right-click the RiskFabric site and select Manage Website > Advanced Settings
   
   The Advance Settings window will open
   
   
4. Reference the Physical Path value
   
   Note: by default, the installation wizard installs the application in the following path:

%SystemDrive%\Program Files\Bay Dynamics\Risk Fabric Server Web

If the path is correct, confirm the web.config file is present in this folder and has a valid connection string pointing to the server hosting Microsoft SQL Server and the RiskFabric database. For example:

<configuration>
  <configSections>
  </configSections>
  <connectionStrings>
    <add name="RiskFabric.Web.Properties.Settings.DatabaseConnectionString" connectionString="Data Source=<hostname_or_IP>;Initial Catalog=RiskFabric;Integrated Security=SSPI;" />
  </connectionStrings>
...

If the path is correct, the web.config exists, and the connection string is correct, determine whether the account under which the installation wizard is running has sufficient permissions to read from and write to this folder.