February 1, 2007 at 9:30 pm
I followed these two articles to get my database mail up and running and everything went well. Sending test email seemed to work as well because I got a sent status recorded in my SQL logs.
http://www.sqlservercentral.com/columnists/cBunch/introtodatabasemailinsql2005.asp
http://www.databasejournal.com/features/mssql/article.php/3626056
However even if I got a sent status in my SQL logs, no email were ever received at the other end. I also checked the logs on my smtp server and I saw no trace of the test email.
So what is wrong?
I did the following:
-Database Mail is enable
-Configuration Component Database account is created
-Database Mail profile is created
-Database Mail account is associated with Database Mail profile
-Grant Database Mail profile access to the msdb public database role and to make the profile the default Database Mail profile.
-Sent test email - results ok except never receive at the other end
Any help would be appreciated, thanks all in advance.
February 2, 2007 at 5:43 am
without any real idea ( but encountered similar issues ) port blocking , windows firewall, group policy - all of these can stop this.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
February 5, 2007 at 8:49 am
On what facts does sql decide to mark the status as sent in the logs? I mean does it communicate with the SMTP server and waiting for a reply of some kind?
Also if you could you give me a bit more info about group policies that are needed I would greatly appreciate?
I checked port blocking following the instructions found here http://support.microsoft.com/kb/153119 and everything seems fine
Thanks
February 6, 2007 at 5:10 am
Hi,
You can confirm by executing sysmail_* commands for more information on database mail (see books online)
thanks
Nag
February 6, 2007 at 5:38 am
as far as I know there is no pass back of the message - although to be honest I normally got some type of error if things were amiss. Could be the mail server is not allowing your mails out .. there's all types of rules in mail servers which work with varying degrees of success! I have responses from ssc sent to my own email as a corporate account always deleted them despite putting in rules about allowing the sender through to my account. The exchnage admin never got to the bottom of it in nearly two years. At my current site I sometimes forward myself mail - most of these never arrive and never get reported as spam. It can be very frustrating!
My last contract had port ( 21 ) I think auto blocked on most servers as a policy, this stopped the mail dead. Sorry can't be more help. I usually resort to sending the mails from management studio to check for an errors.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
February 6, 2007 at 8:43 am
I checked port 25 with telnet and it seems fine but just to be safe I would like to double check. If I am on a server running windows server 2000 where do I go to verify these settings?
[Could be the mail server is not allowing your mails out ..]
Maybe it could be the case but if it is why don't I see traces of the blocked email in the logs of the mail server?
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply