Tuesday, September 11, 2012 10:56 AMI have profile set in my sql server. Test connection is succesful, why can't I received the mail?
Tuesday, September 11, 2012 1:56 PMcheck the database logs for more details. May be you are missing smtp relay access for sql server physical IP.
Please click the Mark as Answer or Vote As Helpful if a post solves your problem or is helpful!
- Edited by RohitGargMicrosoft Community Contributor Tuesday, September 11, 2012 1:56 PM
Wednesday, September 12, 2012 2:33 AMModerator
Please first check the status of e-mail message sent with database mail.
You will see the description for the failed sent. You can troubleshoot the problem by searching the description.
Here are some references about troubleshooting the database mail:
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
- Marked As Answer by Li Yun1 Wednesday, September 12, 2012 11:37 AM
Wednesday, September 12, 2012 11:40 AM
Thanks very much Iric, I found the problem by using your code.
- Marked As Answer by Li Yun1 Wednesday, September 12, 2012 11:40 AM