Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL MAIL Using POP3 and SMTP Expand / Collapse
Author
Message
Posted Thursday, October 21, 2004 4:20 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, June 6, 2014 2:06 PM
Points: 1,040, Visits: 277
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/glarsen/

Gregory A. Larsen, MVP

Need SQL Server Examples check out my website at http://www.sqlserverexamples.com
Post #142888
Posted Tuesday, November 23, 2004 1:42 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, December 8, 2014 8:47 AM
Points: 142, Visits: 64

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
Post #147665
Posted Tuesday, November 23, 2004 7:54 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 22, 2008 2:03 PM
Points: 180, Visits: 35

I am looking for this solution actually, our sqlmail hang everytime after exchange server reboot... your article helps. thanks.




Post #147714
Posted Tuesday, November 23, 2004 11:29 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, November 23, 2004 11:23 AM
Points: 43, Visits: 1
 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.


Post #147772
Posted Wednesday, November 24, 2004 6:36 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, October 13, 2005 7:57 PM
Points: 1, Visits: 1

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. ^_^

Post #148059
Posted Thursday, October 13, 2005 1:27 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 21, 2009 7:21 PM
Points: 1, Visits: 2

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!!

Post #228585
Posted Wednesday, November 23, 2005 7:58 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, July 6, 2012 2:48 PM
Points: 182, Visits: 104
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.
Post #239167
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse