Software Requirements

Server OS, SQL and Dependencies

Server Operating System Requirements

  • Windows Server 2016 and later are supported. IIS must be installed.

  • PowerShell LanguageMode must be set to "FullLanguage".

Check your Language Mode with $ExecutionContext.SessionState.LanguageMode

For more information see https://learn.microsoft.com/en-us/powershell/module/microsoft.powershell.core/about/about_language_modes?view=powershell-7.3

  • Advanced Insights needs approximately 1.5 GB of disk space

  • Minimum 1 CPU Core

  • Minimum 8 GB RAM

CPU and RAM requirements are a minimum for Advanced Insights only and do not consider any other IIS Web sites or Apps running on the same instance.

Windows Server Components and Features

  • Internet Information Services

  • WebSockets (will be added automatically by the installer if missing)

To install IIS on your server outside of the installer you can run this PowerShell command:

Install-WindowsFeature -name Web-Server -IncludeManagementTools

Additional Software Components

  • IIS CORS Module 1.0

  • ASP.NET Core Hosting Bundle 7.0.14 (will upgrade lower versions)

  • SQL Server ODBC Driver 17.6 (minimum)

  • IIS URL Rewrite 2.1

The Advanced Insights installer will automatically install additional software if needed.

Configuration Manager SQL Server

  • Configuration manager SQL Database must be SQL Server 2016 SP1 or later. We strongly recommend ensuring the latest cumulative update is applied to your SQL Server.

  • Database Compatibility Mode must be at least 130 for the Threat Analytics dashboard to load. You will see a warning if this is not met.

If you experience performance degradation in the ConfigMgr Console or Advanced Insights when running the default recommended Compatibility Mode level for your version of SQL Server, reassess whether you may have to change the level to 110. Microsoft have further reading on this here https://learn.microsoft.com/en-us/troubleshoot/mem/configmgr/alerts-reports-queries/sql-query-times-out-or-console-slow-performance

Last updated