Windows 64bit SQL 2005 CLR Mystery

[_shielder_]

Installscript MSI Project:

My 32bit .NET application runs SQL 2005 Express 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:

Error:
“Execution of .NET Framework code is disabled. Set ‘CLR enabled’ configuration option and restart server. (5847)”

Script Code:
CREATE ASSEMBLY MyCode
FROM 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\MyCode.dll'
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.

I also have Custom Action: ISSQLServerInstall In-Script Execution set to Deferred Execution.

So again, this all works on 32bit machines but not on 64bit.

Suggestions?

[_shielder_]

WOW! This is a surprise.

WOW64 servers must be restarted before the changes to this setting will take effect. Restart is not required for other server types.

Link Here...

So now the question is how can I set the CLR On before starting the sever?

[_shielder_]

So I know what the problem is so I've started a new thread here to get that resolved.

I support the “Final Solution” group. Join and help spread the word…