Error: SSAS Server was not discovered

Products

• Information Centric Analytics

Issue/Introduction

The following error message is displayed on the Data Sources page of the Information Centric Analytics (ICA) Installation Wizard when attempting to connect to the SQL Server Analysis Services (SSAS) server:

Connection Error SSAS Server was not discovered. Check the server name.

Environment

Version : 6.x

Component : SQL Server Analysis Services

Cause

This error occurs when the Installation Wizard is unable to query the specified SSAS host server. This can be caused by any of the following conditions:

1. The provided server hostname or IP address is incorrect
2. The Analysis Services service is not running on the target host
3. The Analysis Services service is listening on a non-standard port and that port number was not provided in the server connection string
4. The Windows user account under which the installer is running has not been assigned the server administrator role in SSAS

Resolution

To resolve the conditions listed in the Cause section of this article, refer to the following:

1. Confirm the server hostname or IP address is correct and, if a named instance is being used, include the instance name in the Server connection string using the following format:

   <hostname>[\<instance>]

   For example: ssas.example.com\ica
   
   
2. To confirm the Analysis Services service is running for the target instance, follow this procedure:
   1. From the Windows Start menu, open the SQL Server <version> Configuration Manager
   2. Under SQL Server Configuration Manager, select SQL Server Services
   3. Locate the SSAS instance in which the RiskFabric OLAP cube will be hosted
      Default instance: SQL Server Analysis Services (MSSQLSERVER)
      Named instance: SQL Server Analysis Services (<instance-name>)
   4. If the instance is in a stopped state, right-click the instance name and select Start
      
      
3. If using a non-standard port for the Analysis Services service, specify the port number in the Server connection string using the following syntax:

   <hostname>[\<instance>],<port>

   For example: ssas.example.com,2388 or ssas.example.com\ica,2388
   
   NOTE: If enabled, the SQL Server Browser service listens for incoming connection requests and provides relevant connection resolution details to assist remote services with locating and connecting to SQL Server and Analysis Services instances. This service uses the UDP port 1434. If you are relying on this service for SQL Server or Analysis Services instance name resolution, you need not include port 1434 in the connection string; however, ensure your firewall is configured to allow communications with this service through UDP port 1434.
   
   
4. Per the Required Installation Privileges and Credentials section of the Symantec Information Centric Analytics Administrator Guide, the account under which the Symantec ICA server installation wizard runs requires the following privileges:
   • Microsoft Windows administrator privileges on the IIS (application) and SQL Server host servers
   • System administrator (sysadmin) role in SQL Server
   • Server administrator role in SSAS