SQL CLR not properly enabling

Posted by dnolan on Server Fault See other posts from Server Fault or by dnolan
Published on 2010-03-26T09:00:18Z Indexed on 2010/03/26 9:03 UTC
Read the original article Hit count: 526

We have a SQL server running SQL 2005 Workgroup 64 bit (9.0.4273), on Windows 2003 server 64 bit.

We have run sp_configure and reconfigured the server which indicates that the clr is now enabled.

exec sp_configure 'clr enabled', '1'
go
reconfigure
go

However, when trying to call CREATE ASSEMBLY the server completely dies on us and we have to do a full reboot of the machine.

A little more diagnostic information, even though clr enabled is set to 1 and we have rebooted the full server, running the following statement

select * from sys.dm_clr_properties

returns

directory   
version 
state   locked CLR version with mscoree

which is what it says when the CLR is not enabled on another machine.

On a correctly enabled machine (after reboot) this function reads

directory   C:\Windows\Microsoft.NET\Framework64\v2.0.50727\
version v2.0.50727
state   CLR is initialized

© Server Fault or respective owner

Related posts about sql-server

Related posts about sql-server-2005