February 15, 2011 at 9:12 pm
Ok I am a novice at SQL server 2008
picked up the MCTS 70-432 training book...
I keep getting 'mail cannot be sent because of mail server error'
I have followed the steps many times in the book..
and have done these steps also
and i have gone through the troubleshooting menu of the SQL server 2008....
i have triple checked my account configurations.. and ensured the email and password is correct..
I am using my@att.net email
server name: smtp.att.yahoo.com port: 465
I have checked the SSL.
..
i have selected basic authentication... and ensured my login info is correct...
I even changed the
account retry attempts: 5
account retry delay :60
so it will give the message more chances/time to go through..
but after many many tries.. i still keep getting the same error message...
I even restarted SQLserveragent.. for good measure..
So I am wondering what else should I look for?
perhaps I did something wrong in my set up? or is there a minor detail I am overlooking?
because I have been at this all evening with no luck..
any help is much appreciated..
thank you,
February 15, 2011 at 10:59 pm
iczerz,
Can you show me the errors.
See the gamil account setup. this may be help to you.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
February 15, 2011 at 11:03 pm
1) is database mail enabled?
2) if yes, then have you configured any profile to send mail?
3) if yes, then are you able to send test mail by that profile?
----------
Ashish
February 16, 2011 at 6:12 pm
Ok i looked at the link you gave me and i went into SQLserveragent>properites>alert system> enable mail profile..
when i click it... it lets me choose 'Database mail' and the 'profile' i have already created...
however it wont let me click the 'test' button..
and here are the errors from today and last night..
so yes, i enabled database mail.. and have created a profile and account..
(i have created and deleted many profiles and accounts trying to use different emails..
i found online you can use the free hotmail accounts.. so I am using my paid att.net email..
but that isnt working either)
but am not able to send a test email... as you an see below...
02/16/2011 19:02:39,,Error,205,The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 8 (2011-02-16T19:02:39). Exception Message: Cannot send mails to mail server. (Failure sending mail.).
),6840,50,,2/16/2011 7:02:39 PM,sa
02/16/2011 19:02:14,,Information,204,DatabaseMail process is started,6840,,,2/16/2011 7:02:14 PM,ICZERZ\SQL2008TK432DE
02/15/2011 21:56:33,,Information,203,DatabaseMail process is shutting down,5648,,,2/15/2011 9:56:33 PM,ICZERZ\SQL2008TK432DE
02/15/2011 21:46:53,,Error,202,The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 8 (2011-02-15T21:46:53). Exception Message: Cannot send mails to mail server. (Failure sending mail.).
),5648,49,,2/15/2011 9:46:53 PM,sa
02/15/2011 21:45:33,,Error,201,The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 8 (2011-02-15T21:45:33). Exception Message: Cannot send mails to mail server. (Failure sending mail.).
),5648,49,,2/15/2011 9:45:33 PM,sa
02/15/2011 21:44:12,,Error,200,The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 8 (2011-02-15T21:44:12). Exception Message: Cannot send mails to mail server. (Failure sending mail.).
),5648,49,,2/15/2011 9:44:12 PM,sa
02/15/2011 21:42:52,,Error,199,The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 8 (2011-02-15T21:42:52). Exception Message: Cannot send mails to mail server. (Failure sending mail.).
),5648,49,,2/15/2011 9:42:52 PM,sa
02/15/2011 21:38:07,,Error,198,The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 8 (2011-02-15T21:38:07). Exception Message: Cannot send mails to mail server. (Failure sending mail.).
),5648,48,,2/15/2011 9:38:07 PM,sa
02/15/2011 21:36:46,,Error,197,The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 8 (2011-02-15T21:36:46). Exception Message: Cannot send mails to mail server. (Failure sending mail.).
),5648,48,,2/15/2011 9:36:46 PM,sa
02/15/2011 21:35:26,,Error,196,The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 8 (2011-02-15T21:35:26). Exception Message: Cannot send mails to mail server. (Failure sending mail.).
),5648,48,,2/15/2011 9:35:26 PM,sa
02/15/2011 21:34:06,,Error,195,The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 8 (2011-02-15T21:34:06). Exception Message: Cannot send mails to mail server. (Failure sending mail.).
),5648,48,,2/15/2011 9:34:06 PM,sa
02/15/2011 21:29:39,,Error,194,The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 8 (2011-02-15T21:29:39). Exception Message: Cannot send mails to mail server. (Failure sending mail.).
),5648,47,,2/15/2011 9:29:39 PM,sa
02/15/2011 21:29:12,,Error,193,The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 8 (2011-02-15T21:29:12). Exception Message: Cannot send mails to mail server. (Failure sending mail.).
),5648,46,,2/15/2011 9:29:12 PM,sa
02/15/2011 21:28:47,,Error,192,The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 8 (2011-02-15T21:28:47). Exception Message: Cannot send mails to mail server. (Failure sending mail.).
),5648,45,,2/15/2011 9:28:47 PM,sa
02/15/2011 21:27:19,,Error,191,The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 8 (2011-02-15T21:27:19). Exception Message: Cannot send mails to mail server. (Failure sending mail.).
),5648,47,,2/15/2011 9:27:19 PM,sa
February 17, 2011 at 1:10 am
You have some problem with your smtp server.
1.check the account & password
2.Check the mail server smpt & fire wall too
3.Restart the server and try again
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
February 17, 2011 at 6:55 pm
ok still no luck......
I made sure to enable database mail..
and i went through the steps of configuring again..
and i made sure to restart sql server each time....
any other suggestions?
i configured my settings per these settings:
"
Re: SMTP settings for setting up Outlook 2007 to get xxxx@att.n?et email.Options
AT&T email server settings are displayed in the table below. Use these to set up your email program (e.g., Outlook) for any AT&T email accounts.
Email Program Settings Field: Enter:
Incoming (POP) pop.att.yahoo.com
Outgoing (SMTP) smtp.att.yahoo.com
(requires authentication)
Incoming mail server: POP3
Incoming/Outgoing User Name: Full AT&T email address, including domain (e.g., test@att.net, test@bellsouth.net)
Incoming mail port #: 995, secure connection (SSL) checked
Outgoing mail port # 465, secure connection (SSL) checked
Note: When updating the secure server settings, check the SSL check box first and then update the port number if necessary.
•Haven't set up your email program yet?
For instructions, please visit How do I set up my email account?
•Already set up but want to verify you've got what's shown in the table above?
For instructions, please visit How can I verify my email settings?
The mail server settings above will work with all of the following AT&T domains:
•@ameritech.net
•@att.net
•@bellsouth.net
•@flash.net
•@nvbell.net
•@pacbell.net
•@prodigy.net
•@sbcglobal.net
•@snet.net
•@swbell.net
•@wans.net
Note: As of July 15, 2009, AT&T no longer provides access to Usenet content for AT&T Internet Services customers. Customers wishing to access Usenet newsgroups may do so by finding a third-party provider, who may charge a subscription fee.
"
February 17, 2011 at 6:59 pm
also.. i went ino my firewall program and made sure to allow all connections from SQL Server management studio...
my error reports are the same.
02/17/2011 19:39:45,,Error,267,The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 8 (2011-02-17T19:39:45). Exception Message: Cannot send mails to mail server. (Failure sending mail.).
),7232,59,,2/17/2011 7:39:45 PM,sa
02/17/2011 19:39:25,,Information,266,DatabaseMail process is started,7232,,,2/17/2011 7:39:25 PM,ICZERZ\SQL2008TK432DE
02/17/2011 19:39:05,,Information,265,DatabaseMail process is shutting down,1876,,,2/17/2011 7:39:05 PM,ICZERZ\SQL2008TK432DE
02/17/2011 19:38:33,,Error,264,The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 8 (2011-02-17T19:38:32). Exception Message: Cannot send mails to mail server. (Failure sending mail.).
),1876,58,,2/17/2011 7:38:33 PM,sa
02/17/2011 19:37:12,,Error,263,The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 8 (2011-02-17T19:37:12). Exception Message: Cannot send mails to mail server. (Failure sending mail.).
),1876,58,,2/17/2011 7:37:12 PM,sa
02/17/2011 19:35:52,,Error,262,The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 8 (2011-02-17T19:35:52). Exception Message: Cannot send mails to mail server. (Failure sending mail.).
),1876,58,,2/17/2011 7:35:52 PM,sa
02/17/2011 19:34:32,,Error,261,The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 8 (2011-02-17T19:34:32). Exception Message: Cannot send mails to mail server. (Failure sending mail.).
),1876,58,,2/17/2011 7:34:32 PM,sa
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply