Forum Discussion

Copper Contributor

Mar 25, 2019

System Center 2019 Data Warehouse installation problem

Hi, Installation of System Center 2019 Data Warehouse fails with domain admin (the same user that installed SQL 2017 database and reporting). Error is in the picture below _CreateSRSFolder_SC S...

Icon for Microsoft rank

Microsoft

Mar 29, 2019

Anybody can help with an update?Ovidiu_Pismac1

Jess_Klamath
Copper Contributor
Apr 03, 2019
I found that the service for the SQL Reporting Services is stopping at the beginning of the install. If you restart that service, the product will continue to install.OvidiuPismac
- OvidiuPismac
  Microsoft
  Apr 14, 2019
  Jess_Klamath Started SQL Server Reporting Servcie service during System Center Service Manager 2019 DataWarehouse setup and installer ran but stops in few minutes after with _ConfigureAnalysisServer error. Picture attached
  - OvidiuPismac
    Microsoft
    Apr 15, 2019
    Solved with setting the SQL Server 2017 Analysis Service on DataWarehouse.and Management server from tabular (default installation with SQL 2017) to multidimensional and worked.
    
    Pay attention to SQL 2017 Default Installation of Analysis Service comes with Tabular mode.
    
    Service Manager 2019 does not support Tabular mode of Analysis Service.
    
    https://docs.microsoft.com/en-us/system-center/scsm/release-notes-sm?view=sc-sm-2019
    
    You can change the Analysis Service mode after installation based on this link
    
    https://www.sqlservercentral.com/articles/how-to-change-an-analysis-services-instance-to-tabular-mode
    
    Ovidiu
- OvidiuPismac
  Microsoft
  Apr 04, 2019
  Thank you. I will try and ley you know.

Resources