Error: Analysis Server does not exist

Products

IT Analytics IT Management Suite Server Management Suite Client Management Suite

Issue/Introduction

When trying to enter the name of the SQL Server Analysis Services (SSAS) server into the IT Analytics Configuration page, the following error message is displayed:

Analysis Server '<server-name>' does not exist.

Cause

The SSAS server does not exist or the Symantec Management Platform (SMP) server is unable to access the SSAS server on the network.

Resolution

IT Analytics requires an SSAS server to function, along with a Microsoft SQL Reporting Server (SSRS). If the user has not yet set these up, they must be installed, configured and working before trying to use IT Analytic with them.

Use the following troubleshooting steps to help determine what the issue is, where:

Verify that the server name being used is correct. This is the computer name of the server running SSAS, which may or may not be the SQL Sever name used for the SMP. Try using its hostname, FQDN or IP address as tests to see if any of these three types will enable the connection to work. If not, in a Command Prompt from the SMP, use Ping and NSLookup to verify if it can access the SSAS:
```
ping server_name
```
```
nslookup server_name
```
Do these timeout or outright fail? If so, then either the name is invalid or the SMP cannot access the server across the network. Contact your DBA or Network Administrator for assistance.
Is the SSAS in an instance? If so, this must be specified in the name as server name\instance name. If you are unsure, contact your DBA for assistance.
Is SSAS even installed? On the SQL Server were it is expected to be installed to, log into the Analysis Server. Is this option present or do issues occur? If so, contact your DBA for assistance.
Are SQL and SSAS Windows services started? On the SSAS, go to the Windows Start button > Administrative Tools > Services, then review the SQL services there, specifically SQL Server (MSSQLSERVER) and SQL Server Analysis Services (MSSQLSERVER). Start these if they are stopped, if they are started already, restart them. Warning: Changing Widows services may have a negative impact on databases, such as Altiris, that use them. Consult with your DBA before making changes to these to ensure the production environment is not interrupted.
Can anything other than IT Analytics access the SSAS? For example, can Excel? If not, contact your DBA or Microsoft for assistance. Information on how to do this can be found on Microsoft's web site:

Accessing SQL Server 2008 R2 Analysis Services Data
Ensure that the Application Identity account has sysadmin privileges on the Analysis Service.