June 16, 2005 at 2:32 pm
In the Server Agent Properties, when testing the Mail profile I get an error.
But when I test the Mail profile in the server properties it works fine.
Whats the difference? If it works in the Server properties shoudnt it work in the Agent?
The agent is running.
June 16, 2005 at 4:59 pm
If you've just set up sql mail then I had the same problem some time ago. Basically you just have to restatrt the sql server agent once you've set up the mail profile etc and it should then be ok. Well mine was.
If you don't need to process mail coming in then there a couple of better alternatives to sql mail in the forum links below.
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=105655
http://www.sqldev.net/xp/xpsmtp.htm
SQLMail used to cause me no end of problems none since I used a stored proc to send smtp mail
hth
Dave
June 16, 2005 at 10:18 pm
I 100% agree with David on this. IF you are going to continue using SQLMail though, you need to read the following:
http://support.microsoft.com/default.aspx?scid=kb;en-us;263556
http://support.microsoft.com/kb/315886/EN-US/
Those will solve 99% of any issues encountered with SQLMail. It's a constant struggle though. MAPI sucks in general, so if you can implement another solution, then go for it. Here's a couple more you might consider:
http://www.sqlteam.com/filtertopics.asp?topicID=125
Derrick Leggett
Mean Old DBA
When life gives you a lemon, fire the DBA.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply