Hi,
From past few days i am getting Event ID code “33333” from source “DataAccesslayer” in Operations Manager Log of my RMS. This events are generating in almost every minute.
The error is indicating about to “Enable "clr" configuration option” is SQL server
Text Error Code
From past few days i am getting Event ID code “33333” from source “DataAccesslayer” in Operations Manager Log of my RMS. This events are generating in almost every minute.
The error is indicating about to “Enable "clr" configuration option” is SQL server
Text Error Code
| Event Type: Warning Event Source: DataAccessLayer Event Category: None Event ID: 33333 Date: 31/05/2011 Time: 09:28:41 User: N/A Computer: Foo-BAR Description: Data Access Layer rejected retry on SqlError: Request: MTV_SelectProperty_b87e82bc-1a85-4de3-330a-13133cf5f9c3 -- (ManagedTypeId=994bdf28-10b8-52e4-3334-d65a63d9fe52), (IsDeleted=False), (RegExPattern0=(?i)^10.0..*), (RegExPattern1=(?i)^10.1..*) Class: 16 Number: 6263 Message: Execution of user code in the .NET Framework is disabled. Enable "clr enabled" configuration option. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. |
Solution:
I searched few website and finally I got the solution. The solution is to enable “CLR” option is “OperationsManager” database so that user codes in .NET can executes
To do this Connect to your SQL server and log in to SQL Server management Console.
Right Click the “OperationsManager” database and click on “New Query”
In “New Query windows” type the below code and then click on “Execute”
| sp_configure @configname=clr_enabled, @configvalue=1 GO RECONFIGURE GO |
In Message Pan you will see that it run successfully and “clr” option in changed from “0” to “1”.
After i done this, the error code “33333” not occurred again …
source: TechNet
I hope it helps someone :)
Thanks
Aman Dhally
No comments:
Post a Comment