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