I created dbMail on sql server 2008 SP1 Std. Edition (64-bit). It worked well for a week. However, since then, its not throwing any errors,HOWEVER is neither sending out emails. I can not even receive test dbmails.
1. Does user with sysadmin privs need to be added to msdn dbMailUserRole if set up as an Operator? I hope not!
2.How can i trace out and troubleshoot this problem?
4.I checked with the sysadmin and there were not recent changes on the system. How can i check to see if the port is still open?
Thanks in advance Guys!
I have double checked the following,
Enabled Public profile.
I can ping the SMTP server
have restarted the Agent
and have checked database mail log(for the last week of trials all it says is dbMail process is started LOGID 55 process id 7008, dbMail process is shutting dow LogID 56 process id 7008). BUT NO MAILS!!!
View Complete Post