Sending mails through Sql Server Jobs in 2000

• Sekhar-310813

  Newbie

  Points: 7

  More actions

  March 15, 2006 at 11:23 pm

  #112174

  We have a problem relating to the sql server jobs.

  We have a .net application which sends mails using smtp mail object. This application is called through a sql server job. Mails are going only if the sqlserver agent and the mail from (smtp) is configured to the same user. We are getting a message that "Could not access CDO.Message object", if sqlserver agent service and smtp are configured to different users.

  But our requirement is to have a different users configured for sql server agent and the mail from (smtp).

  Do we have to set any settings in this regard to send the mails through the sql server job. Please clarify in this regard.

  Thanks in advance

• Nali

  SSCommitted

  Points: 1525

  More actions

  March 20, 2006 at 5:55 am

  #627563

  This probably will not anwer your question directly, but its a solution I'm implementing for the same problem. My problem is the user id on Outlook 2000, vs the SQL server user id, which requires a local system account. Anyhow, I'm using xp_smtpmail, see  http://www.sqldev.net/xp/xpsmtp.htm(http://qa.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=261545).