tags:

views:

32

answers:

1
Q: 

Windows 64bit SQL 2005 CLR Install Mystery

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 machines.

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.

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

Suggestions?

+1  A: 

On WoW64 (x86 Express instance installed on x64 host OS) you need to restart the instance for the CLR enabled to take effect, see clr enabled Option:

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

Remus Rusanu  2010-07-02 19:38:48
WOW! This is a surprise. Do you know of a way to set CLR On before the install starts the server?Thanks for the great info...
 2010-07-02 20:19:16
No way afaik. You need to install, and right after the install finishes, run sp_configure to enable clr, then recycle the MSSQL$SQLEXPRESS service via ServiceController.Stop()/Start()
Remus Rusanu  2010-07-02 20:27:01
Or you could install the x64 .msi of Express to start with.
Remus Rusanu  2010-07-02 20:27:41
I appreciate your help on this. I’ve spread this problem across many forums with no results. You’re quite the expert!
 2010-07-02 21:01:17
After I've been burned by this Wow64 restart issue for the thousanth time, I kinda learn it :)
Remus Rusanu  2010-07-02 21:28:40

related questions

ASPX Page Compilation Fails
Does a Silverlight memory profiler exist?
Are static indexers not supported in C#?
(.net) How to support implicit type conversion as well as custom equality
Is there a CLR that runs on the CLR ?
Will .Net 4.0 include a new CLR or keep with version 2.0
Great resources for using the CLR Profiler APIs
Is casting the same thing as converting?
Can you run a version 3 .Net binary on a version 2 CLR install?
Reference .NET Assembly from a SQL Server Stored procedure or function
Should .NET developers *really* be spending time learning C for low-level exposure?
How do I deploy a managed stored procedure without using Visual Studio?
What CLR/.NET bytecode tools exist?
How can I load different endpoints for WCF in SQL CLR?
Can SQL Try-Catch blocks handle thrown CLR errors?
How can you add additional logic to type resolution at runtime?
QDrag destroyed while dragging
How Do VB.Net Optional Parameters work 'Under the hood'? Are they CLS Compliant?
Is there any way to change the .NET JIT compiler to favor performance over compile time?
What's the difference between the inner workings of Java's JVM and .NET's CLR?
CLR Profiler - Attaching to existing process
How can I figure out how much memory a .Net Appdomain is consuming?
How to late bind 32bit/64 bit libs at runtime
Mixed C++/CLI TypeLoadException Internal limitation: too many fields.
LINQ on the .NET 2.0 Runtime