I ran across the “Enable ‘clr enabled’ configuration error” that is shown to the left while moving a System Center Operations Manager 2007 (SCOM 2007) Operations Manager Database.
Source: DataAccessLayer
Category: None
Event ID: 33333
Message: Execution of user code in the .NET Framework is disabled. Enable “clr enabled” configuration option.
To resolve this issue you can, after you successfully moved the OperationsManager database from SQLServer “Old” to SQLServer “New”, enable .NET’s RegEx library. This library is needed to support regular expressions in Operations Manager SQL queries. Operations Manager setup always configures SQL to allow execution of the clr code. When you move a database from one database to another, you lose this “clr enabled” setting in the OperationsManager database.
To resolve this issue run the following query on the OperationsManager database:
sp_configure @configname=clr_enabled, @configvalue=1
GO
Let that command execute successfully then run:
RECONFIGURE
GO
Running these two scripts should resolve the issue for you. Source.
PS:
Do not forget to open your SQL server firewall to the correct ports and the SQL program.
Do not forget to start your services if they are stopped. Or just reboot the Management Server (MS).
I hope this was informative for you.
If you like this post please support phits.nl. Thanks!
