June 3, 2008 at 11:07 am
OK, This is a strange one and I'm hoping for some thoughts on a root cause.
I've got a SQL 2005 Server still on SP1 configured to use Database Mail through a corporate SMTP server. Lots of other servers are using the SMTP server and are configured in the identical fashion, so I'm fairly certain this was not a problem at the SMTP server.
For no apparent reason, all emails from the server suddenly stopped being sent, and the following message appeared in the database mail log:
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2008-06-03T12:04:03). Exception Message: Cannot send mails to mail server. (Command parameter not implemented. The server response was: : Helo command rejected: need fully-qualified hostname).
I had seen this once before, several months ago, and knew that I resolved the problem by deleting and createing the mail profile, so this time I tried changing the smtp server, then changing it back. That had no effect. Again I deleted, then recreated the profile... identically... and it started working again.
Any insight would be particularly helpful.
Warren Campbell
MCSE, MCTS SQL 2005, MCITP SQL 2005 DBA
June 3, 2008 at 12:19 pm
install sp2 if you can
they added alot better error messages for debugging database mail
June 3, 2008 at 12:38 pm
Yeah, that would be the ideal solution, but as this is a QA server for a production system, I can't just install SP2... it will be weeks of paperwork.... "better diagostic information" will certainly be ammo to get the effort to go up to SP2 underway...
Edit: corrected "I can't" not "I Can"
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply