|    
 
Tuesday, January 06, 2009
SSIS Send Mail – Mailbox Unavailable
Scenario:
·         new development SQL Server 2005 server;
·         project to upgrade existing DTS packages to SSIS;
·         to notify users of failure, we wanted to use Send Mail task
·         We got the following error:
Mailbox unavailable. The server response was: 5.7.1 Unable to relay for myemail@mydomain.com).
This was a new server and network administrators assured me that I am using right login and server (and that I do not need to specify username and password for SMTP server).
To take SSIS out of equation, I tried to configure Database Mail and send test email, but I got the same result. After a while I realized that we should use Windows Authentication using Database Engine Service Credentials instead of Anonymous Authentication.
I came back to my SSIS package and set SMTP connection to use Windows Authentication and then everything was working.
I assume that same error can be encountered when you do not have the right name of the account, name of the server…
Print  

Comments
Average rating:  (3.0)
 Hello Dear,, 12/4/2008 
Reviewer: Ann (Any, South Korea)
Hello Dear,

Madam Beverly Ann Murray is my name, I am a deaf and dumb American white woman born 1948 60yrs old of age. I need your help urgently to claim out my consignment with $18.8 million inside deposited with a diplomatic courier service company for safe keeping ship to your place address now as this company management are distrubing me to have it claim out from their company because the date agreement entered with them on the day of deposit for the claiming has expired and i can not do it myself due to present condition of health declining that is why i contact with you,

Awaiting your reply to my private emailbox "madambev@omail.hu" for more details to be given for you to proceed ahead while you confirm to me your capability to handle this consignment in question from the company where is deposited ship to your address by sending to me your full names, your address and your telephone contact if any. Please i want you to be rest assure that in this transaction you wouldn't regret been in partnership with me.
Thank´s as i look forward to hear from you asap.
Regard´s,
Mdm Beverly.
USA

NB:This company management doesn't know the real content of this consignment is money inside, as it was deposited in their company for safe keeping as a files and vital documents inside.
 FSD, 1/22/2008 
Reviewer: DSFDS (DSFD, Bolivia)
FFDSFD

Rating




*
Title *
Comment  *
Name *
City *
Country *
Print  

SSIS Books @ Amazon
Print  

Copyright (C) 2007 Trigon Blue Inc.     |    Privacy Statement    |    Terms Of Use