April 28, 2005 at 2:47 pm
I have been using xp_smtp_sendmail for a long time. I have never had a problem getting it working.
I just brought up a new SQL Server 2000 machine and everytime I try to use it I get the following error:
Error: connecting to server <MY SMTP SERVERS IP ADDRESS>
However on my other 6 SQL Server machines I do not have a problem running the exact same command.
The only real difference is this is the only SQL Server running under Windows 2003 server.
Any help would be GREAT.........
COGunn
April 28, 2005 at 3:07 pm
Check the netstat command from a command prompt. Be sure that there is a listener running for your server on that IP. Also, this could be because the SMTP service isn't running.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
April 29, 2005 at 1:11 pm
Most locations set up their SMTP servers to accept mail from only designated IP addresses. Make sure your new SQL Server is included in the list.
May 20, 2005 at 11:17 am
I thought I better post the solution to this issue.
It turns out that it was the McAfee virus software running on the SQL Server that was blocking the port. The intersting note here is that the same software is running on the other SQL Servers on this same network and SMTP mail functions fine on those.
Thanks for the help.
COGunn
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply