October 21, 2004 at 4:20 pm
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/glarsen/
Gregory A. Larsen, MVP
November 23, 2004 at 1:42 am
Very useful and clear reference Greg, nicely illustrated too, I hope the guys think it's worthy of inclusion in next year's 'Best of' publication - I can never find this information when I need it.
One thing I'd like to point out as a useful addition to it is an article that Microsoft published at : http://support.microsoft.com/kb/311231/EN-US/
Point Q7 is worth reading, as it recommends that you only connect to a POP3 server on your local network, because using a server hosted by an ISP may prove unreliable and cause SQLMail to hang, which requires a restart of SQL Server if you want to send mail again.
Jon
November 23, 2004 at 7:54 am
I am looking for this solution actually, our sqlmail hang everytime after exchange server reboot... your article helps. thanks.
November 23, 2004 at 11:29 am
A very good article but even after setting up sqlmail in the same manner I still have an issue I haven't been able to resolve. I several hours on this an never figured out a solution. I setup everything as describe in this article and others. I could test the process and the first email would work as expected but any after that would que up somewhere and only be sent after a reboot. I test everything I could think of an it all worked properly but only one email would be sent. I was accessing a Novel Groupwise mail server on the network. Any ideas would be welcome.
November 24, 2004 at 6:36 pm
I have used POP3 and SMTP to send SQL Mail for some years. But I succeed little since the ISP's mail server regard our SQL Mails as junk mails to block off. That dismay me.
Now inside company I use Microsoft Windows Server 2003 , the system contain a simple POP3 and SMTP service.
Bob Xu from China. ^_^
October 13, 2005 at 1:27 am
I have 2 instances of SQL running on my server. One of the instances have set the Mail alert and it is working perferct. The other instance don't pass the operator test.
I need to have diferents mail profiles, for more of one instance???
I tested using the same profile or with a second profile set EXACT as the other but don't pass the operator test.
Thanks in advance!!
November 23, 2005 at 7:58 am
Question: Have any of you gotten this to work with Outlook Express? I'm pretty sure I read that full-blown Outlook is required. If so, that's tragic.
I am excited about 2005's inherent SMTP mail capability. I'm looking forward to learning more about it.
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy