January 1, 2009 at 4:21 pm
Boy this database mail will make a person want to say a few bad words !
smtp server is fine.
profiles are set up file
accounts are set up fine
account linked to profile being used.
No error in logs when test mail sent
NOTHING ! JUST NOTHING !
Got any suggestions ?
thanks
Dam again!
January 1, 2009 at 4:44 pm
If you have AV on the server check its configuration. Some will block SMTP communication by default and require adding in the Database Mail executable to its exclusion list.
You might want to verify communication from your SQL server to SMTP server using Telnet; telnet mysmtpserver 25. If it doesn't connect that's a good sign AV is blocking because typically telnet.exe wouldn't be exluded by default.
January 3, 2009 at 10:27 pm
Hi,
i was able to telnet with success to my smtp server.
What is AV?
Dam again!
January 4, 2009 at 1:40 am
AV is Anti Virus. I’ve noticed that you wrote your message in the SQL Server 2000 forum. SQL Server 2000 doesn’t have DBMail. Instead it has SQL Mail. It’s been long time since I’ve last configured SQL Mail with SQL Server 2000, but I do remember that you have to login to the server with the same user that is running the instance’s service when you configure SQL mail. Did you remember to do it or did you use your own credentials?
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 27, 2009 at 7:55 am
I did a update from Microsoft yesterday and had to restart my machine after the update. When the machine restarted I got bombarded by emails from jobs that ran two months ago. "I have it set up to send me emails when a job is run".
So something about restarting the machine triggered my emails to be released from the queue.
Ever seen this happen?
Erik
Dam again!
January 28, 2009 at 11:55 am
When I fisrt started sending e-mail from the SQL Server, the stroed proc I used worked fine, except that there was nothing - NO error message, NO e-mail received.
I found them in the BADMAIL directory
[font="Courier New"]Local Disk (C:)/Inetpub/mailroot/Badmail
Local Disk (C:)/Inetpub/mailroot/Mailbox
Local Disk (C:)/Inetpub/mailroot/Pickup
Local Disk (C:)/Inetpub/mailroot/Queue[/font]
You can also use CDOSYS (Collaborative Data Objects).
You can find detail code example at http://qa.sqlservercentral.com/Forums/Topic527864-110-1.aspx
One point worth mentioning: this does NOT require that Outlook be installed and running on the SQL Server host. And you do NOT have to configure a MAIL account in SQL Server either.
Rgeards
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply