July 23, 2010 at 11:26 am
Hi,
I have configured the database mail in sql server 2005 and it was working fine.But some time suddenly its throwing the error message
" The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2010-07-22T11:14:15). Exception Message: Cannot send mails to mail server. (The operation has timed out.). )"
So i want confirm whether this is due the smtp server by executing the below command
exec xp_cmdshell 'telnet xxxxxxxx.yyyyy.com 25'. But its not giving results as what its giving from command prompt. Its giving result set as null at query analyzer.
Can you give me suggestion to resolve this problem ?
Thanks in advance.
July 23, 2010 at 1:16 pm
Check if some settings on the server is blocking access on Port 25. Also check with the Messaging Team, if they had changed something.
Regarding TELNET not showing the desired result by xp_cmdshell.
In command prompt when you try telnet, if it is successful a blank is displayed.
The same cannot be displayed in SSMS.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
July 23, 2010 at 2:41 pm
Adiga (7/23/2010)
Check if some settings on the server is blocking access on Port 25. Also check with the Messaging Team, if they had changed something.Regarding TELNET not showing the desired result by xp_cmdshell.
In command prompt when you try telnet, if it is successful a blank is displayed.
The same cannot be displayed in SSMS.
ok thanks. do not want exact result set but need some result sets to confirm that telnet command is working fine in ssms.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply