Cannot support Managed Code ? what is this ?

• Gurjit Singh

  Grasshopper

  Points: 16

  More actions

  August 4, 2006 at 4:33 am

  #169654

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

  

   

   

   

   

   

• David.Poole

  SSC Guru

  Points: 76001

  More actions

  August 4, 2006 at 6:04 am

  #653292

  You have to tell SQL2005 that it can use the CLR using the surface area configuration tool

  LinkedIn Profile

• Jeff McCleary

  SSC Rookie

  Points: 37

  More actions

  August 7, 2006 at 6:49 am

  #653557

  I've created a clr SP, and I do know that you do need to enable the server with script like this.....

  sp_configure

  'clr enabled', 1

  go

  RECONFIGURE

  go