SCSM Datawarehouse Analysis Installation Error

Mame Meier 70 Reputation points
2026-03-08T10:42:42.19+00:00

Hi

my setup:

SCSM1 Server 2025/SQL 2022/SCSM Console and Management Server => installation OK

SCSM2 Server 2025 where I am trying to install the datawarehouse part. Remote SQL on SCSM1

On the Analysis installation tab I am getting the error server not found (where server I used scsm1)

Error in log is:

Error:GetSqlInstanceList(), Exception Type: System.IO.FileNotFoundException, Exception Message: Die Datei oder Assembly "Microsoft.AnalysisServices, Version=19.82.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" oder eine Abhängigkeit davon wurde nicht gefunden. Das System kann die angegebene Datei nicht finden.

11:29:46:StackTrace: bei Microsoft.SystemCenter.Essentials.SetupFramework.HelperClasses.SetupValidationHelpers.GetASVersion(StringBuilder sqlInstanceServiceName)

bei Microsoft.SystemCenter.Essentials.SetupFramework.HelperClasses.SetupValidationHelpers.GetSqlInstanceList(String sqlServerName, Int32 serviceType)

MS Analysis Management Objects 16.0.5653.0

MS Analysis Services ADOMD.NET 16.0.5653.0

MS Analysis Services OLE DB Provider 18.0.29.0

MS ODBC Driver for SQL Server 17.10.6.1

MS OLE DB Treiber für SQL Server 18.7.4.0

are installed.

Remote connection is not the issue. As I have tried the local installation of SQL Analysis on SCSM2

Any support is much appreciated

THX mame

System Center Service Manager

1 answer

Sort by: Newest
  1. AI answer

    2026-03-08T10:42:52.7333333+00:00

    The error indicates that the Service Manager Data Warehouse setup on SCSM2 cannot find the required Microsoft.AnalysisServices assembly (version 19.82.0.0) on the Data Warehouse management server. This is a missing client‑side component on the SCSM2 machine, not a remote connectivity issue to SCSM1.

    To resolve the issue, ensure that the correct SQL Server Analysis Services client components and tools are installed on the SCSM2 (DW) server so that the Microsoft.AnalysisServices assembly is available to the SCSM setup framework. After installing/repairing the required Analysis Services client libraries, rerun the Data Warehouse setup and the Analysis Services validation should succeed.

    After the Data Warehouse installation completes, if SQL Server Reporting Services is local to the DW server and is SQL Server 2017 or later, use the verification script described in the documentation to validate the SSRS configuration:

    1. On the Data Warehouse Management Server, download and run the script from this script.
    2. Run it after DW installation; it only verifies configuration and does not change it.

    If problems persist after installing the correct Analysis Services client components, review the Service Manager deployment logs and Windows Event Logs as described in the troubleshooting guidance to identify any additional missing prerequisites or configuration issues.


    References:

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.