sql mail sends mail to nirvana (?)

sql mail sends mail to nirvana (?)

Post by Torst » Wed, 08 May 2002 01:30:36

Hi *

My configuration (everything on one Windows 2000 Server):

SQL Server 7
MAPI from Outlook 2000 client
SMTP-Server from IIS
small testing Pop3-Server (TmPOP3)

After all I got SQL-Mail configured and working, but when testing I
found that most of the time SQL-Mail sends mails that never appear in
the "Drop" directory of the SMTP server - although SQL-Mail reports no
error. "Most of the time" means that there is one mail account that
works, i.e. mails sent to this account are delivered. But all other
accounts don't work.
It should be mentioned that this particular mail account is not the
account for SQL-Mail (and they are not in the same mail profile), it's
just an ordinary account like the other ones that don't work. And when
I use Outlook to send mails to these accounts, the mails are
delivered. So there must be a problem with SQL-Mail, I think. Strange,
isn't is?

Any clues?



1. Send E-Mail Without Using SQL Mail in SQL Server

I have created a stored procedure as described in article
Q312839 and it works. However the message body is
truncated.It seems that the message body is limited to
only 256 characters. Is this correct? Is their something
I'm missing or is there a work around.


Bill C.

2. Reinstall "Enterprise manager"?????

3. Send E-Mail Without Using SQL Mail in SQL Server (Q312839)

4. odbc

5. can sql mail send html e-mail messages?

6. Job Opportunity: U.S.-IL-CHICAGO-SCHAUMBURG

7. SQL MAIL - sending mail

8. Questions on queries in V

9. Can't send mail with SQL Mail and Outlook 2002

10. Problem wtih DTS Task for Send Mail and SQL Mail

11. SQL Mail: mail sent but not devlivery

12. SQL Mail Wont Send E-Mail