My 32bit .NET application runs SQL 2005 SP3 and uses CLR. The install works fine on XP & Vista. The install fails on XP 64bit & Widows 7 64bit.
The error is in one of my SQL scripts that creates an Assembly:
“Execution of .NET Framework code is disabled. Set ‘CLR enabled’ configuration option and restart server. (5847)”
CREATE ASSEMBLY MyCode
WITH PERMISSION_SET = UNSAFE
HOWEVER when I check the CLR it is enabled. In fact my very first script turns the CLR On and Trustworthy On.
So again, this all works on 32bit machines but not on 64bit.