Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

error in send email thru sql server 2005 Expand / Collapse
Author
Message
Posted Friday, April 17, 2009 12:35 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, February 26, 2010 1:58 AM
Points: 1, Visits: 13
Hi Corey Bunch ,

I was trying to send a mail using Database mail option in sql server.I have configures the user account and profle for that database mail.

I could able to send the mails to the user who are under our server But i did n't receive mail to that receiver id

But In sysmail_allitems table sent_status is 'sent'

and couldn't send to others(gmail or yahoo).I am getting the following error.



The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 7 (2008-07-16T12:00:54). Exception Message: Cannot send mails to mail server. (Mailbox unavailable. The server response was: No such user here). )

waiting for ur favourable reply
Post #699137
Posted Friday, April 17, 2009 7:26 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Thursday, July 24, 2014 9:07 AM
Points: 11,157, Visits: 12,899
Have you verified that the email address you provided is correct? The error message says that the user doesn't exist.

I know that I have sent email from an alert to my gmail account.




Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #699402
Posted Friday, April 17, 2009 11:35 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Thursday, July 24, 2014 8:36 AM
Points: 772, Visits: 1,183
Did you try a "Test Email" to that user email address?


If other email address work, then it's an invalid user
If no email address work, it's Database Mail setup issue


SQLServerNewbie

MCITP: Database Administrator SQL Server 2005
Post #699658
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse