xp_sendmail

• Niraj Poudel

  SSC Veteran

  Points: 245

  More actions

  February 1, 2006 at 12:25 pm

  #116129

  Hi,

  I am getting following message when I am trying to run xp_sendmail. I am running service pack 4.

  Please help..........

  Server: Msg 18025, Level 16, State 1, Line 0

  xp_sendmail: failed with mail error 0x80040111

   

  Thank you,

  Nir

• philcart

  SSC-Forever

  Points: 47794

  More actions

  February 1, 2006 at 2:50 pm

  #618227

  

  A quick Google for this error would solve your problem,

  http://support.microsoft.com/default.aspx/kb/315886

  http://support.microsoft.com/kb/238119/EN-US/

   

  --------------------
  Colt 45 - the original point and click interface

• Sameer Raval

  Hall of Fame

  Points: 3214

  More actions

  February 1, 2006 at 2:56 pm

  #618229

   

  If you are using  NT then to fix problem rebuild the profile and then stop and 

  start the sql mail service.

  Another reason for failure is Service startup account  set to the local system account.

   

   

   

  Kindest Regards,

  Sameer Raval [Sql Server DBA]
  Geico Insurance
  RavalSameer@hotmail.com

• Niraj Poudel

  SSC Veteran

  Points: 245

  More actions

  February 2, 2006 at 8:39 am

  #618420

  Thank you all for your help. It works now. Special thanks to Phil.