Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
icw
Constraint Violating Yak Guru
378 Posts |
 Posted - 2007-06-26 : 01:44:18
|
| HiI have set up database mail.I know the settings are correct because I use the same ones for MS Outlook on the same machine.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 6 (2007-06-26T06:25:01). Exception Message: Could not connect to mail server. (No such host is known). )------------------------------------Service broker is enabled.Database mail is started.i really don't know what else it could be....Does SQL Server Agent have anything to do with Database mail?Any other suggestions gratefully accepted..ICW |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-26 : 13:47:53
|
| Db mail requires smtp mail server, different from mapi. |
 |
|
|
icw
Constraint Violating Yak Guru
378 Posts |
Posted - 2007-06-26 : 23:59:23
|
| I know this already but it doesn't help.I have put the address of the SMTP server in the settings of the mail account. |
|
|
|
icw
Constraint Violating Yak Guru
378 Posts |
Posted - 2007-06-27 : 00:15:44
|
| I deleted the account and set it up again and still can't send,althoughthe error message is slightly different.MessageThe mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 6 (2007-06-27T05:11:44). Exception Message: Cannot send mails to mail server. (Service not available, closing transmission channel. The server response was: unable to read controls |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-27 : 23:04:16
|
| But the mail server is invalid based on error message. |
|
|
|
icw
Constraint Violating Yak Guru
378 Posts |
Posted - 2007-06-28 : 00:34:03
|
| HiThanks for taking the time to read my posts and answering.Could i ask you to explain a bit more. I don't quite understand what you mean.ThanksICW |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-28 : 22:55:10
|
| Do you know your smtp mail server name? Can you send mail via that server outside of sql2k5? |
|
|
|
icw
Constraint Violating Yak Guru
378 Posts |
Posted - 2007-07-07 : 00:40:45
|
| yes I can |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-07 : 11:35:29
|
| Then how did you set db mail? |
|
|
|
|
|
|
database mail not working