Database mail problems

• Clark Bones

  Mr or Mrs. 500

  Points: 551

  More actions

  August 17, 2009 at 3:38 am

  #135341

  Hello!

  I have configured SQL Server 2005 SP3 to run under a domain account. Previously it ran under Local System. The domain account is not domain admin. This works well after in most aspects.

  One problem, though:

  Database mail is not working any longer. If I try to send an test e-mail, the e-mail is not delivered, but I can find that it is queued by using the following command.

  sysmail_help_queue_sp @queue_type = 'Mail' ;

  If I use this sql: select * from msdb.dbo.sysmail_event_log

  I can see an "activation failure" message in the log.

  If I start the program DatabaseMail90.exe by double-clicking on it, the e-mails are delivered and the queue is emptied.

  I suppose this is a security config issue? Any ideas?

  Edit: The domain account has full privileges to DatabaseMail90.exe...

• Clark Bones

  Mr or Mrs. 500

  Points: 551

  More actions

  August 21, 2009 at 1:24 am

  #1042632

  No ideas? I need to solve this one...

• Clark Bones

  Mr or Mrs. 500

  Points: 551

  More actions

  August 21, 2009 at 1:29 am

  #1042634

  Sorry for double post...