Posts Tagged enable

How to enable Enable “clr enabled” configuration option

Posted by Le Kevin in Computer on July 31, 2009

If you are working with SQL server CLR objects there’s a higher possibility that you might encounter the following error.

“Msg 6263, Level 16, State 1, Line 1
Execution of user code in the .NET Framework is disabled. Enable “clr enabled” configuration option”

To overcome this, you have to reconfigure the SQL server to enable CLR objects. To do that, you can use the following commands…

exec sp_configure ‘clr_enable’,'1′

RECONFIGURE

Note : – CLR objects only works with SQL server 2005 and later versions.

Share|

, , , ,

No Comments

How to enable 32-bit web server on 64-bit IIS

Posted by Le Kevin in Computer, Database on May 11, 2009

C:\>cscript C:\inetpub\adminscripts\adsutil.vbs SET W3SVC/AppPools/Enable32bitAppOnWin64 1
C:\>cd windows\microsoft.net\framework\v2.0.50727
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>aspnet_regiis.exe -i
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>NET STOP W3SVC /y & NET START W3SVC

Share|

, ,

No Comments