Post reply

Sending mail using send mail task

  • October 29, 2008 at 4:02 pm

    #193047

    I'm trying to send mail using send mail task i guess i set all the properties correctly but it is showing error like

    [Send Mail Task] Error: An error occurred with the following error message: "Mailbox unavailable. The server response was: must be authenticated".

    please help me i got struck in dis thing for more than 2 days

  • October 30, 2008 at 8:55 am

    #891867

    It looks like your server requires authentication and the SMTP Connection Manager supports only anonymous or Windows authentication. Check if your server supports Windows Authentication and then enable this option in the connection manager. If your server doesn't support it, you can check this script. It is based on the SMTP connection manager, but it allows basic authentication with your SMTP server.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • October 30, 2008 at 9:04 am

    #891877

    Thanq crozyroc for your prompt reply

    i'll try that script and let you know whether it worked or not

  • October 30, 2008 at 9:05 am

    #891880

    I get that error all the time when i first setup DBMail

    It just means that either you dont have rights to the SMTP server

    or that you entered a bad ip address

    So i usually call the network guys and tell them i need the sqlserver to have rights to the smtp server box

  • October 30, 2008 at 9:57 am

    #891931

    when i use sp_send_dbmail its working fine

    but i want to do it with send mail task

    so can u please tell me how to give rights to sql server so that send mail task work

Viewing 5 posts - 1 through 4 (of 4 total)

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