I got my DBA scratching his head in front of following error in SSRS. He got the error while sending the mail.
SSRS Failure “sending mail: The message could not be sent to the SMTP server. The transport error code was 0x800ccc6e. The server response was 553 Requested action not taken: No MX record for this domain.”
What was missing was domain name in the email. Email addresse in the TO box of subscription, such as firstname.lastname@example.org, has two parts. The part just before the @ sign is the local part of the address, often the username of the recipient (tuitionaffordable), while the part after the @ sign is a domain name to which the email message will be sent (gmail.com).
I would like the DBA also verify “role based security” verified for smooth run of SSRS report.
INTERVIEW PREPARATION IN 30 MINs – Read Following wires for a quick interview preparation.
- SQL Server DBA “Interview Questions And Answers”
- SQL Azure Interview Questions and Answers Part – 1
- SQL Azure Interview Questions and Answers Part – 2
- Powershell Interview Questions and Answers
Online POWERSHELL Classes @ http://tuitionaffordable.webstarts.com