June 14, 2005 at 7:06 am
Microsoft asserts that SQL Mail is not supported in a clustering environment. However, I've been told that a work-around exists.
I need to be notified if some of my jobs fail on the active node in my cluster. Does anyone know what the SQL Mail work-around is so that I can get alerts working on my cluster?
June 14, 2005 at 7:11 am
SQL Mail and SQL Agent Mail work just fine on a cluster (it's when the SQL Server virtual server fails over that causes the problems). You just have to log into each physical node as the Windows domain account that the SQL Server Agent service is running under and install Outlook and configure a MAPI profile (same profile name on each server). Then you just set up SQL Server to use that profile.
Mail and SQL can be pretty fragile, so you may have to play around with it and troubleshoot it a bit, but it isn't too different than a stand alone implementation.
June 15, 2005 at 7:04 am
I've used SQL mail on clusters and have had issues where mail would stop sending and I couldn't pinpiont why. I think the issue was with the mutliple instances (active/active) though and not neccessarily the cluster. I later had very similar problems on a machine where I ran about 4 instances but was not clustered. I finally decided that the previous advice on the same profile name was the ticket that setteled down the mail.
June 20, 2005 at 5:25 am
I have an interesting setup based on your requirement. You may have to use SMTP Mail instead of MAPI.
I am not sure if you already got the solution as I am too late in replying. If need be I shall post it here.
Viking
June 20, 2005 at 7:26 am
After wrestling with all the work-arounds (and losing) we finally settled on forwarding all events from our clustered servers to a non-clustered server where we have mail nicely, safely, reliably configured. It's worked out pretty well. I wrote a little article on how-to over in the SQL Server Worldwide Users Group a year ago.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply