Weird "clr enabled" error launching SCOM 2016 console

Launching the SCOM 2016 console you might get this:


This event will be logged on the server you're connecting to:

Log name: Operations Manager
Source: DataAccessLayer
Event ID: 33333
Level: Warning
Message: Data Access Layer rejected retry on SqlError:
Request: ManagedTypeByCriteria -- (LanguageCode1=ENA), (LanguageCode2=ENU), (Id0=16781f33-f72d-033c-1df4-65a2aff32ca3)
Class: 16
Number: 6263
Message: Execution of user code in the .NET Framework is disabled. Enable "clr enabled" configuration option.

To fix this, first run this query against the SQL instance for SCOM. The number 1 should be in the value column:

SELECT * FROM sys.configurations
WHERE name = 'clr enabled'

If it isn't, run this:

sp_configure @configname=clr_enabled, @configvalue=1
GO
RECONFIGURE
GO

Update 24/01/2023 - I need to confirm the sp_configure query as it's always been a DBA that runs it.

Comments