Post reply

Logon Failed error on DTS send mail task

  • March 10, 2004 at 12:19 pm

    #63388

    I am getting the following error when creating a send mail task in DTS (SQL2K SP3a Win 2K SP3).

    Error Source : Microsoft Data Transformation Services (DTS) Package

    Error Description: Logon Failed: Unable to get the default MAPI Message Store due to MAPI error 285: You do not have permission to log on.

    I have configured SQL Mail and am receiving notifications from SQL Agent on completed jobs.

    Any Suggestions?

    Thanks.

    Traci

  • March 11, 2004 at 5:46 am

    #498242

    Are you using an account for the MSSQL Server service that has permissions to log on to the mailbox that you are trying to send the email through? SQL Server Agent will use it's service account for sending email however a sendmail taks in dts will use the SQL Server service account.

    Try executing an xp_sendmail from query analyser and see if that works, if not check your MSSQL properties.


    Shamless self promotion - read my blog http://sirsql.net

  • March 11, 2004 at 5:53 am

    #498248

    Here's the only way I was able to get this to work.  Hopefully you can do the same (assuming you are using Outlook for e-mail).

    (1) Create the mail profile on your client computer using the Windows account you use for the SQL Agent.

    (2) Keep Outlook e-mail open using that mail profile.

    (3) Set the profile name in the DTS sendmail task to that mail profile.

    (4) Run the sendmail task using "execute step" to test it. 

    If you are running your DTS pkg from your client machine you'll need to have that mail profile open.  Otherwise when running it as a job or executing on the SQL Server (say from the console terminal) you don't need to do that.

    Good luck!

    Jeff

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply