Hi!

I'm having a problem enabling CLR for the .net framework 2 on 64-bit XP, can
anyone please help?

I am deploying SQL 2005 Express SP2 bootstrapped to my application, as part
of setup I create a database by running TSQL scripts against the server. In
one such script I use the following code to enable CLR:

EXEC SP_CONFIGURE 'show advanced options' , '1';
RECONFIGURE;
EXEC SP_CONFIGURE 'clr enabled' , '1'
RECONFIGURE;

Then the script goes on to load a CLR assembly.

This works great on 32 bit XP and Vista but not 64 bit where I have to
restart the SQL server manaully before the CLR will be enabled. The SQL log
reports that the option has changed and if you look at the sys.configurations
table and the surface area configuration tool you can see that its changed.
However trying to load the assembly causes error 5847: Execution of .Net
framework code is disabled.

Have also tried RECONFIGURE WITH OVERRIDE but doesn't work either.

Any ideas?
Thanks alot!
F