SQL 7's xp_sendmail no longer working since going to Windows2000

[lori]

I was able to successfully use xp_sendmail on my SQL 7/Windows NT 4 server. It worked like a champ. Then we switched to Windows 2000 for the server using the same SQL 7 and xp_sendmail no longer executes. When I try a very simple call to xp_sendmail via the Query Analyzer (xp_sendmail @recipients="lkudlawiec@apa.org", @subject="test&quot, it says "Executing query" and displays nothing - no error messages, no warnings, nothing. I've waited as long as 10 minutes with no good results and then I cancel. I'm fairly certain the SQL Mail Agent is set up correctly. Any advice?

 

[vbuser1976]

did u reset the SQL Mail Agent? Since you changed the config settings of your server, i.e. changing versions, you might need to restart the SQL server agent. Also, I think you might need to reinstall the mail agent, so it can recognize the new OS. I am not sure about this, but this is the first things I would do. One other thing, have you tried checking the microsoft technet to see if this is a known issue? Good Luck and let me know what happens. -vbuser1976
VB6.0 SP5
Crystal 8.0 Developer Edition
SQL 7.0 SP2

http://ccsco.homestead.com