Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
share|improve this question
    
Any errors? or just dies silently? – gbn Apr 4 '10 at 12:18
    
dies silently, no event log entries or anything in sql event log – dnolan Apr 6 '10 at 14:41

The query may not be display the CLR version properly if you don't have VIEW SERVER STATE permissions on the server.

Check your login that is running the query has VIEW SERVER STATE permissions. One method is grant that login 'db_owner' to the database and re-run the query, you should get the correct results then.

More info about sys.dm_clr_properties: [https://msdn.microsoft.com/en-nz/library/ms174983.aspx]

share|improve this answer
    
Thanks for the reply nik, it's nearly 6yrs since we had this issue though and we no longer have the server in question so I cannot prove if your suggestion would help. – dnolan Mar 4 at 9:15

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.