Database mail error about clr and lightwight pooling

• calin_c84

  Old Hand

  Points: 304

  More actions

  December 19, 2011 at 2:24 am

  #249970

  Hello all.

  I'm trying to enable Database mail on a mssql 2005 server. I've done this for 2 servers until now,without issues, but now I receive the following error:

  CLR execution is not supported under lightweight pooling....

  Can someone explain me what is happening,because I don't understand the connection between database mail ,clr and lightweight pooling.

  Thanks in advance!

• Bhuvnesh

  SSC Guru

  Points: 59351

  More actions

  December 20, 2011 at 11:02 pm

  #1424009

  This will help you. i guess your CLR functionality is disabled

  sp_configure 'show advanced options', 1;

  GO

  RECONFIGURE;

  GO

  sp_configure 'clr enabled', 1;

  GO

  RECONFIGURE;

  GO

  -------Bhuvnesh----------
  I work only to learn Sql Server...though my company pays me for getting their stuff done;-)