May 9, 2004 at 2:53 am
Hi everybody:
I have the following configuration:
SERVER1: windows server 2003 and sqlserver 2000. I have installed XPSMTP (xpsmtp80.dll)
SERVER2: windows 2000 server and sqlserver 7.0. I have installed XPSMTP (xpsmtp70.dll)
SERVER3: windows 2000 server and smtp virtual service.
All three servers are in the same domain and the sql server service is run by the domain administrator.
XPSMTP provides a SMTP based SQL Mail solution for sending MIME based email over SMTP, implemented as an Extended Stored Procedure.
I send an email from SERVER2 (using the smtp service of SERVER3) and it works, but when I send the same email from SERVER1 (using the same smtp service of SERVER3) it doesn't work. In that case the error message is the following: Server response: 550 5.7.1 Unable to relay for To@hotmail.com
The email I am sending, in both cases, is the following:
exec master.dbo.xp_smtp_sendmail
@FROM = 'From@hotmail.com',
@TO = 'To@hotmail.com',
@cc = '',
@BCC = '',
@priority = 'HIGH',
@subject = 'Test',
@message = 'Hello',
@type = 'text/html',
@attachment = '',
@attachments = '',
@codepage = 0,
@server = 'aaa.bbb.ccc.ddd' --This is the ip address of the smtp server
Why it happens if I have using the same smtp server in both cases?
Some body can help me?
Thanks in advance.
May 12, 2004 at 11:01 am
Check that the open relay on the smtp server is allowing relaying from both SQL Server IP addresses.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply