System Manager - Configure analysis services for OLAP cubes error - PLEASE HELP :(

Question

Hi guys,

Banging my head against the wall here and driving myself crazy..

I am seeing the below error when getting to the configure Analysis Servicer for OLAP cubes section of the Data warehouse (Previously working but not working via system centre now so reinstalling via the setup to fix)

]2

I have followed every forum and post I can find but nothing helps. Followed this as well: https://social.msdn.microsoft.com/Forums/en-US/145149e6-ad56-478c-876a-3ab691ad4fa0/configure-analysis-services-for-olap-cubes-not-able-to-connect?forum=dwreportingdashboards

The error message I get in the setup log is the below:

Any help would be amazing as this one has got me going crazy.

System centre 2019
SQL 2017
All SQL accounts have correct access

Answer 1

Hi @Alfie Thomas ,

Welcome to Microsoft Q&A! Sorry about that I just working with SSAS, not familiar with System Manager. So I added some related tags for your thread.

Based on my research, system Center Service Manager 2019 requires SQL Server Analysis Services (SSAS) to work with Microsoft Online Analytical Processing (OLAP) cubes. With SQL 2017 the default SSAS mode is Tabular. Service Manager’s Management Server and Data Warehouse only work with SSAS mode Multi-Dimensional and not Tabular. For more information, please refer to SCSM doesn’t work with default SSAS mode on SQL 2017.

In addition, is your scenario same as the link which you provided? Were you install SSAS and SQL Server successful? Have you get any error message when you trying to connect to SSAS from SSMS? If yes, please provide more error details. I think provide more details about your scenario can let you more easier get helps from here.

Hope below tips could help you to fix this error:
Default instance listens to TCP port 2383. If the client does not use a port number or an instance name, and it is TCP connection, the client will try reach TCP port 2383. Make sure this port is open in the firewall. The best way to test if this port is open is to use telnet. SSAS instance can only accept Windows authentication. Anonymous Login is not a valid Windows account to access SSAS.

Best regards,
Carrin

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.