July 22, 2003 at 1:04 pm
Hi,
I have set up SQLMail on few of my regular servers by installing Outlook and create a mail profile that connects to an account I've setup on our Exchange Server.
Now I want to do the same to one of my clustered machine, my question is - are there any special instructions of how to install Outlook (/Office2000) on a clustered server? Should I install separately on both nodes, is it cluster "aware", etc...
Thanks!
July 22, 2003 at 2:14 pm
You can configure the SQLmail in a clustered environment, but its not stable. You cannot guarantee the availability. MS says SQL Mail is not fully Functional on a Cluster due to the MAPI limitation of not being cluster aware
Shas3
July 22, 2003 at 3:13 pm
I agree with Shas3. It's doable, make sure the profile names are identical, etc. Make sure you set up the profile identically on both sides. But at the end of the day, remember that it's not fully supported and every once in a while it will hang.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
July 22, 2003 at 5:08 pm
Thanks guys.
My worst fear is that installing Office2000 on both nodes may interfere or hurt the SQL Server stability in any way. Should I be worried about that, or installing Outlook on both nodes shouldn't do any harm?
Thanks again
July 23, 2003 at 1:05 am
I've had sqlmail running on my clustern, knowing it is not supported and knowing it needs a server-reboot evert +- 6 weeks. According to the users-responsable, this was no problem.... until it got stuck when they needed it or when they couldn't have downtime ! Now I've installed smtp-mail, but also there I have an issue that I cannot explain yet. You could go the the http://www.sqldev.net solution with the XP, but I havn't tested that because I tried to use a solution without extra dll's. If you want it, I can post my sp_ALZ_SQLSMTPMail, which is a modified version of Clinton Herring's sp_sqlsmtpmail.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
July 23, 2003 at 5:34 am
I am also aware it's not supported, however I have seen it to be very stable as long as it's installed on all nodes, the same profile is used (preferably the same account as the cluster service and sql service), AND -- any "hanging" that may be experienced -- is probably more related to an inability to resolve email names than anything else. We see this on non-clustered environments. If you've ever experienced the "dialog box" to help you select "which email account you want" -- if that same dialog box "pops up" because SQLMail is trying to send an email where the name can't fully be resolved -- sqlmail will "hang"-- indefinitely.
July 23, 2003 at 6:32 am
quote:
is probably more related to an inability to resolve email names than anything else. We see this on non-clustered environments.
This is very true. We see it, too. Hence a switch to Perl, SMTP, and a job scheduler outside of SQL Server in our environment.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply