Network Management

Active Diagnostics tests on SQL Server and Database Collation incorrectly Warn on supported collations for SolarWinds Observability 2022.4 and above

This article addresses an issue where the Active Diagnostics feature incorrectly issues warning messages about SQL Server and database collations that are supported by SolarWinds Observability products.

First published date

1/9/2026 12:30 AM

Last published date

1/12/2026 7:14 PM

Overview

In SolarWinds Platform (formerly Orion Platform) versions 2022.4 and later, customers may encounter a warning in Active Diagnostics (AD) stating that the SQL Server or database collation is not supported—even when using a supported collation such as Latin1_General_CI_AS. This warning is a false positive and does not impact the functionality or stability of the SolarWinds Platform. The issue has been observed across multiple environments and is confirmed to be cosmetic only.

SolarWinds Platform supports the following collation settings:

English with collation setting Latin1_General_CI_AS
English with collation setting SQL_Latin1_General_CP1_CI_AS
English with collation setting SQL_Latin1_General_CP1_CS_AS
German with collation setting German_PhoneBook_CI_AS
Japanese with collation setting Japanese_CI_AS
Simplified Chinese with collation setting Chinese_PRC_CI_AS

Product section

Orion Platform

Cause

The issue arises from a misalignment between the deployment validation logic and the expected collation data checks. This causes the deployment validation process to inconsistently verify supported collations, leading to incorrect warning messages during Active Diagnostics.

Resolution

This behavior has been acknowledged by the SolarWinds development team, and a tracking item has been created to improve the accuracy of collation checks in future releases.

Importantly, this warning does not indicate any operational issue or incompatibility with the supported collations. The SolarWinds platform functions correctly with the collations listed above despite the erroneous warnings.

Recommendations for users:

You can safely ignore these incorrect collation warnings in Active Diagnostics for now.
Continue to use supported collations as documented.
Monitor for updates from SolarWinds that address this validation logic in upcoming product versions.

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third-party content at your own risk, and you will be solely responsible for the incorporation of the same if any.