Database Mail issue

  • Hello,

    Have setup the database for one of my instances running SQL 2k5 Dev Edition RTM.

    However, i'm unable to send test mails...

    Error message from database mail log says:

    The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 2 (2009-05-25T09:36:28). Exception Message: Cannot send mails to mail server. (Failure sending mail.).

    I'm using my office email to setup this... I know the exchange server name where my profile resides and the smtp address...

    Unfortunately, I've no control on exchange server...

    Any cues?



    Pradeep Singh

  • I would suggest using either a command line or GUI SMTP tool on your server ot cinfirm that you can connect to your mailrelay and send mail outside of SQL server, once you get that too work then you can transfer the settings to Database Mail.

    On the other hand if you cannot get your SMTP tool to work right, then you knwo to look at your smtp settings, your network (firewalls etc.) or your mail server access & configuration.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.
    [/font]
    [font="Verdana"] "Performance is our middle name."[/font]

  • Hi,

    Thanks for the reply.

    Would you please let me know how and what needs to be checked in the SMTP setting?

    Ryan
    //All our dreams can come true, if we have the courage to pursue them//

  • Your send mail task should have an SMTP connection manager associated with it (SmtpConnection property). Open that connection manager to check its settings:

    - SMTP server:

    - Use windows authentication

    - Enable SSL

    Write these down, then goo to you network manager ask her/him if these are the correct settings. If they are not, then correct them and try again. If they are correct, then ask your network manager how you can best test SMTP connectivity outside of your package, BUT *still* on the same server (they should be able to do this).

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.
    [/font]
    [font="Verdana"] "Performance is our middle name."[/font]

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

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