IT Analytics requires an SSAS 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:
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:
- Ensure that the Application Identity account has sysadmin privileges on the Analysis Service.
Error "Analysis Server 'servername\instance' does not exist" occurs when clicking on the Verify Connection button in IT Analytics when ports 2382 and 2383 are blocked
Error "The remote name could not be resolved" occurs when trying to access IT Analyics Configuration
How to install, configure and troubleshoot IT Analytics