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 |
|
Mathias
Posting Yak Master
119 Posts |
 Posted - 2009-10-06 : 03:52:41
|
| We have just upgrade to SP3 4035 this week end and the database mail is no longer working. I got the error: success 2009-10-06 09:27:03.257 Activation successful.information 2009-10-06 09:27:03.867 DatabaseMail process is startedinformation 2009-10-06 09:33:15.413 The mail queue was started by login "LU40MONT0000\Polo".error 2009-10-06 09:34:22.997 The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2009-10-06T09:34:23). Exception Message: Cannot send mails to mail server. (The specified string is not in the form required for an e-mail address.). )information 2009-10-06 09:45:23.067 DatabaseMail process is shutting downAny clue? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-10-06 : 03:58:18
|
It seems email address is not valid"The specified string is not in the form required for an e-mail address"
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
Mathias
Posting Yak Master
119 Posts |
Posted - 2009-10-06 : 04:03:14
|
| The addresses haven't changed : the addresses remained unchanged : they worked all fine before SP3 and are no longer working today. |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2009-10-06 : 08:45:22
|
| Any unusual characters in the mail addresses?Any unusual character encoding involved? |
|
|
|
Mathias
Posting Yak Master
119 Posts |
Posted - 2009-10-06 : 09:39:31
|
| Under Managing Account (Database Mail Configuration Wizard)I had the following in the reply email:to person1@md.com; person2@md.comby changing it to to person1@md.com, person2@md.comIt solved the problem (changing the ";" to ","). What is strange is that I didn't get an issue before moving to sp3.I have now another problem, when I receive the email and click on reply, only person1@md.com is showing and not both. Any idea? |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2009-10-07 : 09:42:01
|
| When you receive the mail do you see both "person1" & "person2" in the "cc" list?also are you "replying" or "replying to all"?I don't use "datebase mail" so my questions are coming from a "general probing" angle rather than from any particular epxerience/insight into this product. |
|
|
|
|
|
|
sp3 4035 - Database mail not working anymore