Greetings!

I am in hopes that someone will be able to shed some light on the problem I am having. I am using SQL 2000’s SQL Mail service to generate emails programmatically. I have been using VB applications calling stored procedures to start and send emails in-house with no problem. However, I am now trying to use the same code/procedures to send emails to vendors outside of our domain and the process fails. All looks good but the mail never arrives. I have also tested this to my yahoo email account with the same results. Any help you might be able to provide will be most appreciated!!

Chris

Chris,

Take a look at your event logs or SQL Server error logs. It is failing somewhere and the place to start looking is the logs (event and sql server).

Let us know what you find.


Scott Klein
Author - Professional SQL Server 2005 XML
http://www.wrox.com/WileyCDA/WroxTit...764597922.html

You will probably have to enable email relaying which is off by default. You then need to make sure that it can't be used by by malicious users for spamming etc.

--

Joe (Microsoft MVP - XML)