4.2. Enabling CLR Integration
CLR integration is turned off by default in SQL Server 2005. Use the sp_configure system stored procedure to enable CLR integration, as shown here:
sp_configure 'clr enabled', 1 GO RECONFIGURE GO
The clr enabled server configuration option specifies whether .NET assemblies can be run by SQL Server (0 = do not allow; 1 = allow). The change takes effect immediately after sp_configure and reconfigure are executedthe server does not need to be restarted.
You need ALTER SETTINGS permissions at the server level to enable CLR integration.