If you want to run managed code in SQL Server 2005 you need to change the default setting for CLR Enabled from false to true.
To do this, run:
exec sp_configure 'clr enabled', '1'reconfigure