Article ID: 298723 - Last Review: March 18, 2006 - Revision: 2.3

BUG: SQL Mail may not be fully supported for use with virtual SQL Servers

View products that this article applies to.

System TipThis article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.

This article was previously published under Q298723

BUG #: 213525 (SHILOH_BUGS)

Expand all | Collapse all

SYMPTOMS

SQL Mail may fail to work at all or after a cluster failover has occurred.

Back to the top

CAUSE

Messaging Application Programming Interface (MAPI) is not cluster-aware.

Back to the top

WORKAROUND

To use SQL Mail with SQL Server 2000 failover clustering, consider the following:

An instance of SQL Server 2000 must run on the same Microsoft Windows NT/2000 account on all failover cluster nodes in order for SQL Mail to possibly work on failover clusters.
Each failover cluster node must have a MAPI profile with an identical name and settings.

Back to the top

STATUS

Microsoft has confirmed this to be a problem in SQL Server 2000.

Back to the top

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.

For additional information, refer to the following subjects in SQL Server 2000 Books Online: