cluster email notofication | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

cluster email notofication

All,
When i needed to use email notifications in the past with a sql cluster I had to "forward" events and messages to a non clustered server with a MAPI client installed. This is because outlook 2000 and previous was not cluster aware. Does anyone know if Outlook 2003 is cluster aware? Does anyone have a better alternative to using outlook for SQL email notofication? For a cluster? TIA
Outlook 2003 won’t work. Until SQL Server 2005, your best option is to use SMTP in some fashion, or use a third party monitoring tool. We use a third-party tool for server monitoring and it works well. —————————–
Brad M. McGehee, MVP
Webmaster
SQL-Server-Performance.Com
As suggested by Brad, SQL Mail is not fully supportable when used on a SQL Server failover cluster due to the MAPI limitation of not being cluster-aware. For alerting functions, use another monitoring tool such as System Monitor that is running on another computer. Review information from thishttp://www.databasejournal.com/features/mssql/article.php/1585201 article about using SMTP email.
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
I might have the wrong end of the stick here but,
We use SQL mail notifiations, both from the sql agent (using outlook 2000) and the SP (connecting to a clustered EX2k adv instance) with an active / passive SQL2k cluster on Windows 2k.
We just had to create a mapi profile (by logging on as the account that runs SQL agent, and configuration outlook) on each node.
I not saying it’s supported but it works for us. My appoligies if I have misunderstood the issue. Phil
SQL Mail is not fully supportable when used on a SQL Server failover cluster due to the MAPI limitation of not being cluster-aware. For alerting functions, use another monitoring tool such as System Monitor that is running on another computer.
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
I agree with Phil. We also use SQL Mail in our Cluster environment. It works great with no issues. We have Active/Passive cluster and we did create same MAPI profile in both the instance. Gopal
]]>