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
Post a Comment