question

AlfieThomas-0908 avatar image
0 Votes"
AlfieThomas-0908 asked CarrinWu-MSFT edited

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

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)

![139552-image.png][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:

139537-image.png


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

System centre 2019
SQL 2017
All SQL accounts have correct access

[2]: /answers/storage/attachments/139572-image.png

sql-server-generalsql-server-analysis-servicesmsc-service-manager
image.png (92 B)
image.png (64.3 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered

Hi @AlfieThomas-0908,

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.