Clustering, sending mail from SQL Server in a cluster

We consolidated sending SQL Server mail from one box in our enterprise,
which has worked out well for us. Now we'd like to consolidate
servers/databases and put it under a clustered environment. But how do we
handle the mail ?
Thanx.
-Cqlboy
Try xpsmtp from www.sqldev.net. It isn't a seamless drop-in, but it is a
lot easier to handle than Outlook on a cluster node. It IS a very stable
component.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Cqlboy" <Cqlboy@.discussions.microsoft.com> wrote in message
news:CC3E45B3-D309-49A9-95D0-0B05C9541665@.microsoft.com...
> We consolidated sending SQL Server mail from one box in our enterprise,
> which has worked out well for us. Now we'd like to consolidate
> servers/databases and put it under a clustered environment. But how do we
> handle the mail ?
> Thanx.
> -Cqlboy
|||Or you could try this if you have iis smtp server installed on the box.
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:%23hk$d6k%23EHA.3756@.TK2MSFTNGP14.phx.gbl...
> Try xpsmtp from www.sqldev.net. It isn't a seamless drop-in, but it is a
> lot easier to handle than Outlook on a cluster node. It IS a very stable
> component.
>
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Cqlboy" <Cqlboy@.discussions.microsoft.com> wrote in message
> news:CC3E45B3-D309-49A9-95D0-0B05C9541665@.microsoft.com...
>
begin 666 sp_SendCDONTSEmail.sql
M04Q415(@.4%)/0T5$55)%('-P7U-E;F1#1$].5%-%;6%I; T*0$9R;VT@.=F%R
M8VAA<B@.Q,# I+ T*0%1O('9A<F-H87(H,3 P,"DL#0I 0T,@.=F%R8VAA<B@.Q
M,# P*2 ]("<G+ T*0$)#0R!V87)C:&%R*#$P,# I/2 G)RP-"D!3=6)J96-T
M('9A<F-H87(H,3 P,"D]("<G+ T*0$)O9'D@.=F%R8VAA<B@.T,# P*3TG)RP-
M"D!!='1A8VA0871H('9A<F-H87(H,3 P*3TG)RP-"D!!='1A8VA.86UE('9A
M<F-H87(H,3 P*3TG)PT*#0I!4PT*#0I$14-,05)%($!#1$].5%,@.:6YT#0I$
M14-,05)%($!H<B!I;G0-"D1%0TQ!4D4@.0%)E='9A;"!I;G0-"D1%0TQ!4D4@.
M0'-O=7)C92!V87)C:&%R*#,P*2 -"D1%0TQ!4D4@.0&1E<V,@.=F%R8VAA<B@.R
M,# I#0H-"D5814,@.0&AR/7-P7T]!0W)E871E(")#1$].5%,N3F5W36%I;"(L
M($!#1$].5%,@.3U54#0H@.(" @.248@.0&AR(#P^(# @.1T]43R!%<G(-"@.T*15A%
M0R! :'(@./2!S<%]/05-E=%!R;W!E<G1Y($!#1$].5%,L("=-86EL1F]R;6%T
M)RP@., T*(" @.($E&($!H<B \/B P($=/5$\@.17)R#0H-"D5814,@.0&AR(#T@.
M<W!?3T%39710<F]P97)T>2! 0T1/3E13+" G1G)O;2<L($!&<F]M#0H@.(" @.
M248@.0&AR(#P^(# @.1T]43R!%<G(-"@.T*15A%0R! :'(@./2!S<%]/05-E=%!R
M;W!E<G1Y($!#1$].5%,L("=4;R<L($!4;PT*(" @.($E&($!H<B \/B P($=/
M5$\@.17)R#0H-"D5814,@.0&AR(#T@.<W!?3T%39710<F]P97)T>2! 0T1/3E13
M+" G0V,G+"! 0T,-"B @.("!)1B! :'(@./#X@.,"!'3U1/($5R<@.T*#0I%6$5#
M($!H<B ]('-P7T]!4V5T4')O<&5R='D@.0$-$3TY44RP@.)T)C8R<L($!"0T,-
M"B @.("!)1B! :'(@./#X@.,"!'3U1/($5R<@.T*#0I%6$5#($!H<B ]('-P7T]!
M4V5T4')O<&5R='D@.0$-$3TY44RP@.)U-U8FIE8W0G+"! 4W5B:F5C= T*(" @.
M($E&($!H<B \/B P($=/5$\@.17)R#0H-"D5814,@.0&AR(#T@.<W!?3T%39710
M<F]P97)T>2! 0T1/3E13+" G0F]D>2<L($!";V1Y#0H@.(" @.248@.0&AR(#P^
M(# @.1T]43R!%<G(-"@.T*248@.0$%T=&%C:%!A=&@.@./#X@.)R<@.#0H)0D5'24X-
M"@.E04DE.5"! 071T86-H4&%T: T*+2T)15A%0R! :'(]<W!?3T%-971H;V0@.
M0$-$3TY44RP@.(D%T=&%C:$9I;&4B("P@.0$%T=&%C:%!A=&@.@.3U54( "P@.0$%T
M=&%C:$YA;64@.3U54#0H)15A%0R! :'(]<W!?3T%-971H;V0@.0$-$3TY44RP@.
M(D%T=&%C:$9I;&4B("P@.3E5,3"P@.($!3;W5R8V4]0$%T=&%C:%!A=&@.@.3U54
M("P@.0$9I;&5.86UE/4!!='1A8VA.86UE($]55 T*"4E&($!H<B \/B P($=/
M5$\@.17)R#0H)14Y$#0I%6$5#($!H<CUS<%]/04UE=&AO9"! 0T1/3E13+" B
M4V5N9"(-"B @.("!)1B! :'(@./#X@.,"!'3U1/($5R<@.T*#0I'3U1/($1O;F4-
M"B @.(" -"D5R<CH-"B @.("!204E315)23U(@.*"=%<G)O<B!S96YD:6YG(&5M
M86EL('5S:6YG(&-D;VYT<RX@.)RP@.,38L(#$I#0H@.(" @.15A%0R!S<%]/04=E
M=$5R<F]R26YF;R!.54Q,+"! <V]U<F-E($]55"P@.0&1E<V,@.3U54#0H@.(" @.
M4T5,14-4(&AR/4-/3E9%4E0H0DE.05)9*#0I("Q :'(I+"!S;W5R8V4]0'-O
M=7)C92P-"B @.(" @.(" @.9&5S8W)I<'1I;VX]0&1E<V,-"@.T*1&]N93H@.(" @.
E#0H@.(" @.15A%0R!S<%]/041E<W1R;WD@.0$-$3TY44PT*1T\-"@.``
`
end
|||IIS on a SQL cluster host? Not my ideal setup.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Steve Woodhams" <stevew@.globalnet.co.uk> wrote in message
news:7tidnZ2tgt39cXrcRVnyig@.brightview.com...[vbcol=seagreen]
> Or you could try this if you have iis smtp server installed on the box.
>
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:%23hk$d6k%23EHA.3756@.TK2MSFTNGP14.phx.gbl...
a[vbcol=seagreen]
stable
>
>
|||Rather have iis than use outlook. Anyway our final solution was to just have
a send email stored procedure that writes to a table. We then have a .net
service that just reads the table and sends the emails from another box
using cdonts.
Shout if you want the source.
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:%23kMCyJl%23EHA.2156@.TK2MSFTNGP10.phx.gbl...
> IIS on a SQL cluster host? Not my ideal setup.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Steve Woodhams" <stevew@.globalnet.co.uk> wrote in message
> news:7tidnZ2tgt39cXrcRVnyig@.brightview.com...
> a
> stable
>
|||Greg Linwood wrote a series of articles on how to build an asynchronous
email system around xpsmtp. I would probably go with that if I needed
anything more sophisticated than what I built.
Thanks,
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Steve Woodhams" <stevew@.globalnet.co.uk> wrote in message
news:09OdnfD8y5d7cnrcRVnyiQ@.brightview.com...
> Rather have iis than use outlook. Anyway our final solution was to just
have[vbcol=seagreen]
> a send email stored procedure that writes to a table. We then have a .net
> service that just reads the table and sends the emails from another box
> using cdonts.
> Shout if you want the source.
>
>
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:%23kMCyJl%23EHA.2156@.TK2MSFTNGP10.phx.gbl...
is
>
|||"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:%23kMCyJl%23EHA.2156@.TK2MSFTNGP10.phx.gbl...
> IIS on a SQL cluster host? Not my ideal setup.
>
Actually this is exactly what we do. But not the way you're thinking.
We use xp_sendmail quite a bit (mostly because it's so convenient for
scheduled tasks to use it.)
Then we use the SMTP component only (no web, ftp services) of IIS on the
same box and point the Outlook client to that. That prevents it from
locking up due to Outlook timing out due to the SMTP server not being
available.
Then of course the SQL server is completely firewalled off from the outside
world, so no one can connect to any ports on it.
Since I've done this and installed SP3a I don't think I've had a single
issue with SQL Mail. Oh, and this is on a cluster that's failed over at
least once.
[vbcol=seagreen]
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Steve Woodhams" <stevew@.globalnet.co.uk> wrote in message
> news:7tidnZ2tgt39cXrcRVnyig@.brightview.com...
is[vbcol=seagreen]
> a
> stable
enterprise,[vbcol=seagreen]
do
>