SQL Server Performance

cluster email notofication

Discussion in 'SQL Server Clustering' started by detroit, Jun 1, 2004.

  1. detroit New Member

    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
  2. bradmcgehee New Member

    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
  3. satya Moderator

    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.
  4. phil.holmes New Member

    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
  5. satya Moderator

    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.
  6. gopal Member

    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

Share This Page