problem with xp_smtp_sendmail

Hi friends, i have trying to make a procedure to send an email tom my
e-mail account using xp_smtp_sendmail, but y
have a problem and i don't know why i dont receive any message. I make ping
to the server and it works but when i run this:
declare @.rc int
exec @.rc = master.dbo.xp_smtp_sendmail
@.FROM = N'dep.tecnico@.prmconsultores.com',
@.TO = N'dep.tecnico@.prmconsultores.com',
@.server = N'smtp.prmconsultores.com'
select RC = @.rc
go
the result of rc=1 and any message is send.
Someone can help me.
thanks in advance.
Sure, try to connect to the mailserver you are sending to. Use telnet
for this to clarify if the server accepts non-authenticated relaying
(most productional server don=B4t do this).
-Open the commandline
-type: telnet <Servername> 25
-type: helo
-type: mailfrom:<YourMailAdress>
-type: rcptto:<ReceiptientMailAdress>
-type: data
-type: <two returns>
Mail will be send OR and error message will be presented (eventually
during the steps above).
Post the error back if any.
HTH, jens Suessmeyer.
|||Thanks for help. I have tried to make telnet
telnet smtp.prmconsultores.com 25
but it returns error like this:
connection error, can't open the connection to the host to 25 port
i think that the host don't accepts non-authenticated relaying as yuo say.
thanks any way.
"Jens" <Jens@.sqlserver2005.de> escribi en el mensaje
news:1137756243.009895.16250@.g43g2000cwa.googlegro ups.com...
Sure, try to connect to the mailserver you are sending to. Use telnet
for this to clarify if the server accepts non-authenticated relaying
(most productional server dont do this).
-Open the commandline
-type: telnet <Servername> 25
-type: helo
-type: mailfrom:<YourMailAdress>
-type: rcptto:<ReceiptientMailAdress>
-type: data
-type: <two returns>
Mail will be send OR and error message will be presented (eventually
during the steps above).
Post the error back if any.
HTH, jens Suessmeyer.
|||Wait a minute, wait a minute. The attempt you made was just below the
application layer. So there might be a connection problem rather than a
authentification problem. "Denied relying" is presented when you
connect successfully to the remote computer and stated the command
above. If the server above is public you can be sure that unknown
mailservers are blocked. But a way around would be to install a virtual
SMTP server (like this one which comes with IIS) and relay the message
to a trusted mail server and then send it with credentials to a public
webserver.
HTH, jens Suessmeyer.