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

[Prashant]

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]

I would check your firewall settings.

[email]GertD@SQLDev.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@yahoo.com> wrote in message
news:3c56224f.0409271209.47759098@posting.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