SQL Sentry DCOM errors in Windows Event Viewer

The Windows Event Viewer will frequently report DCOM errors related to SQL Sentry. 

The SQL Sentry rolling log will report errors collecting WMI information from servers.

-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.

Adding the 'SqlSentryAzureMode' config flag to the SentryOne Monitoring Service config file should resolve these specific DCOM errors. (The screenshot below provides an example)

Add the SqlSentryAzureMode config flag to versions 2021.8 through 2023.3 of SQL Sentry:

1. Stop the SQL Sentry Monitoring Service(s).
2.  Locate the SentryOne.App.MonitoringService.exe config file (C:\ProgramFiles\SentryOne\XX.0).

3.  In the <appSettings> add a key as follows:
     <add key="SqlSentryAzureMode" value="true" />
 
4. Save the file.
5. Restart the Monitoring Service(s).

------------------------------------------------------------------------------------

For SQL Sentry versions 2023.4 and higher, the following SQL Sentry DB feature flag can accomplish the same task.

1. Insert the following feature flag in the SQL Sentry database.

-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.

INSERT INTO [FeatureFlag]
([Name], [Enabled])
VALUES ('SqlSentryAzureMode', 1)

2. Restart the Monitoring Service(s).