Professional Web Applications Themes

could not connect to SMTP server from sql server using JMail, xp_smtp_sendmail or sp_send_cdosysmail - ASP Components

I am trying to send an email message from sql server using the JMail component from dimac.net. I was able to use the stored procudure sp_send_mail from the Jmail usage examples successfully using sql server installed on the development machine and a smtp server. If I use another sql server installation (the production machine) and the same smtp server, the stored procedure does not work and I get the above mentioned error message. I searched extensively on groups and forums and have not come across a solution. I got similar error messages with xp_smtp_sendmail from sqldev.net and also sp_send_cdosysmail. The ...

  1. #1

    Default could not connect to SMTP server from sql server using JMail, xp_smtp_sendmail or sp_send_cdosysmail

    I am trying to send an email message from sql server using the JMail
    component from dimac.net. I was able to use the stored procudure
    sp_send_mail from the Jmail usage examples successfully using sql
    server installed on the development machine and a smtp server.
    If I use another sql server installation (the production machine) and
    the same smtp server, the stored procedure does not work and I get the
    above mentioned error message. I searched extensively on groups and
    forums and have not come across a solution. I got similar error
    messages with xp_smtp_sendmail from sqldev.net and also
    sp_send_cdosysmail. The basic error was that the sql server machine
    could not connect to the smtp server box.
    Is there some SQL Server setting that is responsible for this
    behaviour? Or is my deduction completely wrong and there is actually a
    simple solution?
    Any help/clues will be appreciated!

    Thanks
    Prashant
    Prashant Guest

  2. #2

    Default Re: could not connect to SMTP server from sql server using JMail, xp_smtp_sendmail or sp_send_cdosysmail

    I would check your firewall settings.

    [email]GertDSQLDev.Net[/email]

    Please reply only to the newsgroups.
    This posting is provided "AS IS" with no warranties, and confers no rights.
    You assume all risk for your use.
    Copyright SQLDev.Net 1991-2004 All rights reserved.

    "Prashant" <pras_punjabi> wrote in message
    news:3c56224f.0409271209.47759098posting.google.c om...
    >I am trying to send an email message from sql server using the JMail
    > component from dimac.net. I was able to use the stored procudure
    > sp_send_mail from the Jmail usage examples successfully using sql
    > server installed on the development machine and a smtp server.
    > If I use another sql server installation (the production machine) and
    > the same smtp server, the stored procedure does not work and I get the
    > above mentioned error message. I searched extensively on groups and
    > forums and have not come across a solution. I got similar error
    > messages with xp_smtp_sendmail from sqldev.net and also
    > sp_send_cdosysmail. The basic error was that the sql server machine
    > could not connect to the smtp server box.
    > Is there some SQL Server setting that is responsible for this
    > behaviour? Or is my deduction completely wrong and there is actually a
    > simple solution?
    > Any help/clues will be appreciated!
    >
    > Thanks
    > Prashant

    Gert E.R. Drapers Guest

Similar Threads

  1. Replies: 2
    Last Post: September 12th, 10:44 PM
  2. Replies: 0
    Last Post: August 23rd, 05:27 PM
  3. Can't connect to SMTP server
    By bburkettaz in forum Coldfusion Server Administration
    Replies: 0
    Last Post: May 18th, 12:11 AM
  4. Replies: 0
    Last Post: July 1st, 02:04 PM
  5. Replies: 7
    Last Post: June 10th, 02:11 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139