xp_sendmail - attaching files requires an integrated client login

• Bosco2

  Ten Centuries

  Points: 1240

  More actions

  November 29, 2010 at 9:46 am

  #147874

  I am using SS 2005 and can send an email successfully without an attachement BUT when I attach a file I get:

  "xp_sendmail: The client connection security context could not be impersonated. Attaching files require an integrated client login"

  We moved physical locations of all our servers/network but nothign has changed with the SS permissions.

  Any idea what might have changed that would cause this? Is this a network issue?

  Thank in advance.

• Adiga

  One Orange Chip

  Points: 27284

  More actions

  November 29, 2010 at 1:28 pm

  #1256473

  This error message is because you have selected Authentication from SQL Server Login. Please change it to Windows Only.

  http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/2ad7cf73-695f-4770-bc7b-f68ed6281649/[/url]

  http://www.sqlservercentral.com/Forums/Topic478323-359-1.aspx

  Since you are using SQL Server 2005, it would be better to migrate to a more robust Database Mail.

  Pradeep Adiga
  Blog: sqldbadiaries.com
  Twitter: @pradeepadiga