This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- InstallShield
- :
- InstallShield Forum
- :
- Windows 64bit SQL 2005 CLR Mystery
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
Jul 02, 2010
11:51 AM
Windows 64bit SQL 2005 CLR Mystery
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?
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?
(2) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
Jul 02, 2010
03:26 PM
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?
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?
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
Jul 06, 2010
02:54 PM
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…
I support the “Final Solution” group. Join and help spread the word…
![](/skins/images/8CE4FAD0DE6F3A6F9D0567434D2D2DAE/responsive_peak/images/icon_anonymous_message.png)