在EventViewer看到启动程序时遇到错误：ERROR: EXECUTION OF USER CODE IN THE .NET FRAMEWORK IS DISABLED. ENABLE CLR ENABLED CONFIGURATION OPTION

By default .NET Framwork is disabled in SQL2005.

How to fix:

1. Explore "SQL Server 2005/Configuration Tools/Surface Area Configuration" in your Start menu. 

2. Select "Surface Area Configuration for Features"

3. You will find "CLR Integration" option, activate it and save.

 

In SQL2008 How to Fix:

1. Run below sql script to enable CLR in SQL2008

sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'clr enabled', 1;
GO
RECONFIGURE;
GO