Does Sql Server 2005 Enterprise Edition Support Managed Code ?

Dear friends,

please help,

let me tell you what happens,

1) first i installed Sql Server 2005 Enterprise Edition, everything was working fine except i was not able to create managed objects from BI, like stored procedures, triggers, UDT, etc etc.

2) so i installed VS.net 2005 complete + Sql Server 2005 Express Edition

now i was able to create stored procedures, triggers, etc etc, i'm talking about the CLR objects, ok, i.e. the managed code, but........ i was only able to do this from Sql Server 2005 Express Edition.

whenever i try to create managed objects CLR like stored procedures and stuff from the Sql Server 2005 Enterprise edition it gives me the following error :

"The Sql Server supplied by these connection properties, does not support managed code, please choose a different server"

please help meeeee.. please please, tell me what's the problem ?

below i'm attaching a screenshot of the error....

first off, I ASSURE you SQL Server 2005 EE supports SQLCLR. http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

secondly, sql server 2005 has CLR Integration turned off by default and if you were to attempt using a sql 2005 EE default install/instance you could still deploy the sqlclr routines, its just that upon attempting to use them you would receive the error "Execution of user code in the .NET Framework is disabled. Enable "clr enabled" configuration option."

I can only reason that you are in fact NOT connecting to a SQL Server 2005 instance from a Visual Studio 2005 database project.

|||

yes even i think i was using, sql server 2000 your right.

thanks for your kind help,

regards,

Gurjit Singh

sql