I received an email today saying there was a problem with one of our SQL Server 2000 servers sending mail. I found the following error in my test:
exec xp_sendmail '[email protected]', ' Hello, 123 '
xp_sendmail: Failed resolution due to message error 0x80004005
There has been little focus on the SQL Server 2000 Server at hand. In the past, this server has occasionally been unable to send mail problems, usually by stopping the SQL Mail client session and then restarting the SQL Mail client session to operate, sometimes this method does not solve the problem, can only be resolved by restarting the SQL Server service. The first time I encountered this problem, I first went to the control panel to check "Mail Configuration", Outlook configuration is OK. I tried to stop the mail client session using the script below, but this error message also appears when xp_startmail.
exec Master.dbo.xp_stopmail
exec Master.dbo.xp_startmail
The last discovery is that there is a problem with the Exchange server. caused this error, the system administrator resolved the Exchange Server problem, xp_sendmail immediately normal. There is also a case on the Internet: because the server's mail is full or closed, this error will also occur, the sender (server) mailbox emptying can solve the problem. Because xp_sendmail these things are obsolete, there is no need to study the need for learning. But it is still a record of this case, to facilitate the subsequent occurrence of similar problems, can be quickly resolved.
xp_sendmail: Failed due to message error 0x80004005