October 22, 2009 at 1:33 pm
Hi all
I have configured XP_smtp_sendmail proc in my production DB with SQL Server 2000 Enterprise Edition SP3. and copied XPSMTP80.dll when I excute the job i got an error as
Executed as user: NT AUTHORITY\SYSTEM.
Error: Sending Message[SQLSTATE01000]
(Message 0) Server response : 554 Relay rejected for policy reasons. [SQLSTATE01000] (message 0). The step failed.
Can anybody tell me how to resolve this error.
Thanks
October 23, 2009 at 8:18 am
Looks like you have some kind of connectivity problem with your SMTP server. Have you talked to your Email admin? One other issue I've seen with DBMAIL in SQL Server 2005, which could be possible with xp_smtp_sendmail is that AV can block sending emails and you don't necessarily get a good or consistent error message for that so check your AV logs as well.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 23, 2009 at 10:29 am
That error is because your smtp server is not allowing relay, you can change that option on the mail server, but for security reasions it's recommended to be disabled.
Maybe you are using a FROM address that is not within your domain.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply